Allowing Network Connections

Before SQL Express will allow connections from a remote computer, you must use the Surface Area Configuration Tool to enable access via TCP/IP.

1. Launch the tool from Microsoft SQL Server 2005->Configuration Tools->Surface Area Configuration
2. Choose "Surface Area Configuration for Services and Connections" when prompted
3. Expand MSSQLSERVER, Database Engine, Remote Connections
4. Select Local and Remote Connections, Using TCP/IP only and press OK
5. Restart the server (or the MSSSQL Service).

Firewall Considerations

If you are behind any other firewalls and require client connection from outside the firewall, you must forward TCP port 1433 to your database server.

If you are using the built in Windows 2003 or XP firewall, you must create an exception to allow incoming connections on 1433