Error:
Sometimes you may get this below Error while connecting to SQL Server instance:-
“A network-related error 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”
There might be several reasons for you getting above error and Below are few points you have to check to troubleshoot and resolve this error.
- you have to Make sure that SQL server you are trying to connect is up and running. Ping the Server IP from the client machine.
- If the Server is up, then you have to make sure the SQL Server is up and running. To verify sql server is running – go to SQL Server configuration manager (Start > All Programs > SQL Server 2005/2008/R2> Configuration Tools > SQL Server Configuration Manager)
- Click on SQL Server Services on the left hand side and ensure the SQL Server (MSSQLSERVER/your instance name) Service is running.
- you should Check that the SQL Browser service is running. If you have installed a SQL Server named instance and not configured a specific TCP/IP port, incoming requests will be listening on a dynamic port. To resolve this issue you should have to SQL Browser service enabled and running.
- you need to Check the TCP/IP and Named Pipes protocols and port. Open SQL Server Configuration Manager and check the SQL Server Network Configuration protocols. You should enable Named Pipes and TCP/IP protocol.
- you should check and Try to connect telnet from client machine to check SQL Port is open or not from firewall.
Hope it will help many of them to fix this issue…