HRcalendar - Solution To: Client Can't Connect to the Server

Client Connection Issues

OPTION A:

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.

OPTION B:

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)
• TCP/IP

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.

Reference Documentation:

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)