SQL server Error 53 – FIX

Leave a comment (0) Go to comments

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)

SQL server Error 53   FIX SQL Error

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

SQL server Error 53   FIX SQL Error


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.

SQL server Error 53   FIX SQL Error

Solution 3

Verify that Remote connection is enabled by Right Click on SQL Server instance go to properties and then connection.

SQL server Error 53   FIX SQL Error

Solution 4

Ensure that SQL Service port is opened at firewall.

Solution 5

In case you are using SQL Server 2005, then

  1. Enable the TCP/IP protocol using the Surface Area Configuration Utility
  2. Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility

SQL server Error 53   FIX SQL Error

SQL server Error 53   FIX SQL Error

This solution will resolve this SQL error 53.

EOF - SQL server Error 53 – FIX, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.