Setting up SQL Server

Posted on 2009-12-21
Last Modified: 2012-05-08
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
Question by:GregMcL
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    >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 )
    LVL 20

    Accepted Solution

    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)


    Author Closing Comment

    Lots of reading still to go

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now