Unable to connect SQL Server 2005

  • Article

What is the reason that you unable to connect to the SQL Server 2005 and received following error message:

[XXXX]SQL Server does not exist or access denied. [XXXX]ConnectionOpen (Connect()).

 

Microsoft SQL Native Client : 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.

Microsoft SQL Native Client : Login timeout expired

This is because to connect to SQL Server Database Engine you must have a network protocol enabled. You can use SQL Server Configuration Manager to enable, disable, and configure network protocols.

Please refer to this site: https://msdn2.microsoft.com/en-us/library/ms187892.aspx on how to configure the network protocols.

 

The protocol must be enabled on both the client and server to work. The server can listen for requests on all enabled protocols at the same time. Client computers can pick one, or try the protocols in the order listed in SQL Server Configuration Manager.