A network-related or instance-specific error occurred while establishing a connection to SQL Server

 

ERROR MESAGGE:

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)”

EXPLANATION:

You may encounter an error message when connecting to SQL Server Instance.

SOLUTION:

There are several reasons why you might get this error.

  • You may not have specified the SQL Server name correctly.
  • The SQL Server name that you specify is correct; but the SQL Server service is not running.
  • You may not have opened SSMS with Run As Administrator.
  • You may not have the necessary privileges on the port on which SQL Server is running.(you should check your company’s firewall).

The problem will be solved when you are sure that the above steps are correct.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

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