Servicing Director Applications Error: "Connection failed ... No connection could be made ..."

Servicing Director Applications Error: "Connection failed ... No connection could be made ..."

Connection failed:

SQLState: '08001'

SQL Server Error: 10061

[Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.

Connection failed:

SQLState: '08001'

SQL Server Error: 10061

[Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. 


Root Cause:

This is a Microsoft SQL error caused by either your SQL server network settings or your network configuration.

Workaround:

Have your local IT or administrator review the current status of your Microsoft Windows computers and networking, both on the Servicing Director applications computer and on the Microsoft SQL server.

The Servicing Director applications rely on Microsoft Windows provided components to connect to your Microsoft SQL Server, and this message means those Microsoft provided components cannot communicate.

On the application computer, it uses the Windows Microsoft Native Client (ODBC) components, and on the Microsoft SQL Server computer, it uses SQL Server TCP/IP network protocol.

Refer to your Microsoft SQL Server support resources for the procedures to make sure your SQL Server is online and able to communicate over your TCP/IP network. Make sure your applications computer can connect to your SQL Server over the TCP/IP network to the network port defined by your SQL Server. 

ArticleNumber:

000042697