Setting up SQL Server

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
Who is Participating?
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
SQL Express, is not configured for network access by default.

You need:
Set SQLEXPRESS to allow remote connections through TCP (disabled by default)
Start (set automatic) "SQL Server Browser" service (not enabled by default)
Allow port 1433, 1434 if you use firewalls
Install (or alter afterwords) security for Mixed mode on SQL Server (default is not mixed mode)

Aneesh RetnakaranDatabase AdministratorCommented:
>I would like to able to access the sql server from multiple sites, is this possible ?
Yes , thats what a server meant to do
by default it uses the ports 1433 and 1434
you dont really need any special configuration, install the server on one of those machines, connect with your application (you have to change the connection string )
GregMcLAuthor Commented:
Lots of reading still to go
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.