sqlserver related questions

Question

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.

Answer 1

Hi @Buddhai ,

This is a general SQL server connection error message, please follow below steps to troubleshoot this issue:

1. Make sure SQL Server Service is running
2. If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct and there is actually such an instance on your target machine.
3. Make sure SQL Server is configured to allow remote connections
4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports
5. Test server connectivity with PING from the client machine
6. Test port connectivity using TELNET to the server and port (from step 4) from the client machine.  For example,

TELNET <server-name> 1433

7. Check firewall settings if step 5 or 6 connectivity test fails

 If you have some confuse about the steps, please refer to MS document A network-related or instance-specific error occurred while establishing a connection to SQL Server to get more information.

 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.