HRcalendar - Client can't connect to the server

Client Connection Issues

OPTION A

HRcal Server Install.png

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

first.JPG

 

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

2nd.JPG

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:

http://support.microsoft.com/kb/265808

How to configure a Server to Listen on a specific TCP Port (SQL Server Configuration Manager):

http://msdn.microsoft.com/en-us/library/ms177440.aspx

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.