Client Connection Issues
During installation of the client, the database instance will default to SQLEXPRESS or MSSQLSERVER (if your server is running full-fledged SQL). If you encounter issues using MSSQLSERVER, change it to SQLEXPRESS.
Go to SQL Server Configuration Manager and verify that the following are Running and the Startup Mode is set to Automatic.
- SQL Server (SQLExpress)
- SQL Server Browser
Select Protocols for SQLEXPRESS and verify that the following three items are Enabled:
- Shared Memory
- Named Pipes (To support WINS)
Go into each protocol and set each Enabled to Yes. In the TCP/IP, verify that Listen All is set to Yes.
In the TCP/IP Properties screen, select the IP Address tab.
Disregard IP3 and IP4. Only configure IPALL, making sure the TCP Dynamic Ports field is empty by removing the 0. Verify that the TCP Port is 1433.
How to connect to a named instance of SQL Server 2005:
How to configure a Server to Listen on a specific TCP Port (SQL Server Configuration Manager):