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

Welcome to designerdairy blog, Here we are going to see how to resolve  below error when we connecting the sql server.

Step 1: 

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)

Step2:

Go and open  "SQL Server Configuration Manager"

Step3 :

Click on "SQL Server Network Configuration" and Click on "Protocols for SQL Express"

Right hand side click  on "TCP/IP" (make sure it is Enabled) Click on Properties

Step4 :

Double click on "TCP/IP",  pop up dialog boxes open, there you will find two tabs  Protocols and IP Addresses

Step5 :

Now Select "IP Addresses" Tab -and- Go to the last entry "IP All"

Enter "TCP Port" 1433.

Step6:

Now go to (WinKey + r) and  type "services.msc" and restart the MSSQL$SQLEXPRESS

Step7:

The problem will get resolved. Enjoy folks Happy Coding...!