Causes For Network Related Errors in SQL Server

Posted on : 10-01-2012 | By : Devi Prasad | In : Configuring SQL Server, SQL Errors, SQL Server Basics, SQL Server Management, SQLServerPedia Syndication

Share:

2


Following are the main reasons for network related errors in SQL Server.

1) Server/Instance name is wrong
Fix: Check for the correct name of the Server/Instance and try to connect again

2) SQL Server Service is not running on the Server Machine.
Fix: Start the SQL Server service on the Server Machine.
Steps to start the SQL Server Service:
– Run -> Services.msc
– RightClick on SQL Server (MSSQLSERVER)
– Click on Start

Start SQL Server Service

Start SQL Server Service

3) SQL Server instance Service is not running on the Server Machine.
Fix: Start the SQL Server instance service on the Server Machine.
Steps to start the SQL Server instance Service:
– Run -> Services.msc
– RightClick on SQL Server (instancename)
– Click on Start

4) SQL Server Browser Service is not running on the Server Machine.
Fix: Start the SQL Server Browser service on the Server Machine.
Steps to start the SQL Server Browser Service:
– Run -> Services.msc
– RightClick on SQL Server Browser
– Click on Start

5) TCP/IP is disabled on the Server Machine.
Fix: Enable TCP/IP
Steps to enable TCP IP On SQL Server
Open SQL Server Configuration Manager
– Allprograms ->( Microsoft SQL Server 2008 R2 (or) Microsoft SQL Server 2008 (or) Microsoft SQL Server 2005 ) -> SQL Server Configuration Manager

Open SQL Server Configuration Manager

Open SQL Server Configuration Manager

– Expand SQL Server Network configuration
– Click on protocols for MSSQLSERVER (If its an instance click on the respective instance name)
– RightClick on TCP/IP and click on enable

Enable TCP IP

Enable TCP IP

6) Firewall does not allow connections to SQL Server Service.
Fix: Add exception to Firewall to allow connections to SQL Server Service.

7) Firewall does not allow connections to SQL Browser Service.
Fix: Add exception to Firewall to allow connections to SQL Browser Service.

8 ) Remote connections are disabled on SQL Server
Fix: Allow remote connections on sql server
Steps:
– Connect to SQL Server on SSMS
– RightClick on Server
– Click On Properties
– In the Server Properties Popup Select Connections
– Check the Allow remote connections to Server and click on OK

Allow Remote Connections to Server

Allow Remote Connections to Server

9) Time out errors due to network latency
Fix: Increase Remote Query Time out
Steps:
– Connect to SQL Server on SSMS
– RightClick on Server
– Click On Properties
– In the Server Properties Popup Select Connections
– Increase the Remote query timeout value and click on OK

Remote Query Time Out

Remote Query Time Out

10) Invalid Credentials
Fix: Fetch the latest creadentials to login into the server or ask the administrator to give your credentials necessary oermissions on the server.

(Visited 1,051 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Comments (2)

[…] The following post helps you understand the basic reasons for network related errors in sql server Causes For Network Related Errors in SQL Server […]

muito obrigado, me ajudou muito thanks 🙂

Write a comment



Tags: