I am looking at setting up an SQL Server in my office, and am after some advice on how to configure it to get the best results. I have a SBS2003 with a static IP, and am looking at setting up SQL Server Express on another machine in the network probably running XP and use Access 2007 as a front end.
I would like to able to access the sql server from multiple sites, is this possible ? What is the best way ? ie setting up ports etc.
Currently I'm trying to get a plan together, to see if I can make this work, so any help would be appreciated