SQL ERROR 53 : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
This is the very Common Error, while establishing a connection to the server when connecting to SQL server ,
What / When / Why we get this Error ?
We normally get this error while connecting to SQL Server. we get this error because
- Remote connection is not allowed
- TCI/IP protocol is not enable.
- SQL Services are running on different port
How to fix sql Server Error 53 ?
This error can be either by
Solution 1
Enabling TCP/IP protocol for SQL Server.
Open Start >> Programme >> Microsoft SQL Server >> Configuration tools >> SQL Server Configuration Manager and enable the TCP IP Protocol
Solution 2
Connect to to Correct SQL services port. First check on which port SQL services are running and specify the port number during establishing connection.
See my old post for this.
Solution 3
Verify that Remote connection is enabled by Right Click on SQL Server instance go to properties and then connection.
Solution 4
Ensure that SQL Service port is opened at firewall.
Solution 5
In case you are using SQL Server 2005, then
- Enable the TCP/IP protocol using the Surface Area Configuration Utility
- Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility
This solution will resolve this SQL error 53.