Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: 2)

TITLE: Microsoft Visual Studio
------------------------------
Failed to connect to server .
------------------------------
ADDITIONAL INFORMATION:
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: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
The system cannot find the file specified
------------------------------
BUTTONS:
OK
------------------------------

Solution:

1.Check for working fine SQL Server Services running or not.

2.Also check for working in good condition SQL Server (MSSQLSERVER).
3.Also check for working fine SQL Server Browser.

4.Delete all earlier Aliases, now create new aliases as per your requirements.

5.Now check for working of SQL Server Default Port 1433

6.Next click on Client Protocols in instance, then click on TCP/IP, now click on mouse right click, open the Property, here you can make assure your working fine your default port SQL 1433.

 

7.Open your SQL Server Management Studio, then right click, click on "Property" option and then click on Connections tab, then finally tick for Allow remote Connections to this server.

8.Check for right working or your Ping IP Host.