Hi Sir,
I am having a doubt regarding one of the issues in SQL Server. Can you help me to find out the root cause? While trying to connect to a remote sever, I am getting the following error.
Error: 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).
Kindly suggest.
Thanks,
Anoop
Unable to connect to Remote SQL Server
Posted June 30, 2012
Comments
Hi Anoop,
From the error, it seems the your source SQL server is not able to connect to the destination server. This can happen because of many reasons like either the Destination server is down or SQL Services are stopped or any network issue as well. Kindly first check if the destination server is up and running by executing the PING command. If it is fine, then check with the network team on this.
Thanks,
Sujeet
The best diagnostic for testing connectivity is to issue the following command from a command prompt:
telnet sqlserver port
where sqlserver is the name of the sql server and port is the port on which sql server is listening (typically 1433). If you do have connectivity, you will get a blank screen in the command window. If not, you will get a timeout.
Displaying all 2 comments