Techies Adsense

Wednesday, 31 August 2016

A network-related or instance-specific error occurred while establishing a connection to SQL Server

<Steps to resolve the Issue "A network-related or instance-specific error occurred while establishing a connection to SQL Server" described in this article for SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL SQL Server 2014 As well for Coming SQL Server Version steps will remain same.

Complete 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) (Microsoft SQL Server, Error: 1326)



Step by Steps Solution: I have described in detailed below to resolve the SQL Server Error:


Step 1.

Try to find SQL Server Configurations Manager. in your Windows => All Programs
Step 2.

Expand the "SQL Server Network Configurations "



Step 3.
Next to select TCP/IP and it should be Enabled.
Step 4.

Next go to the next Tab "IP Addresses"



Step 5. Open SQL Server Management Studio and login into SQL Server Database Engine with sa Account. and  Next Click on Security Tab => and Enable SQL Server Windows and SQL Server Authentication Mode.



Step 6. Next Click on Connections Tab And Allow Remote Connections.  


Step 7. Now Check the SQL Server Instance Services it can be done using shortcut command "services.msc" and set Service as "Automatic".


Step 8. Go to => Control Panel\All Control Panel Items\Windows Firewall Or directly run the command "firewall.cpl" to open Firewall Management and Allow SQL Server Port "1433" for Remote Access: 


Step 9 Click Next And Allow Connection for remote Access.



 Step 10: Now check your SQL Server Should be accessible remotely.


Simple Command you can perform : Open Windows Command Prompt. and Type :

C:> telnet your-server-host-ip 1413


Thank you for the visit If you are still having issue please don't hesitate to reach me by Gmail, Facebook,





No comments: