Network-related or instance-specific errors occur when you establish a connection with SQL Server. Server not found or inaccessible

Network-related or instance-specific errors occur when you establish a connection with SQL Server. Server not found or inaccessible

When I started the system this morning, I found that I could not log on to the database when I opened SQL Server Management Studio in SQL Server 2008 and entered the sa password? The following error message is displayed:

"Network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL Server is configured to allow remote connection. (Provider: named pipeline provider, error: 40-unable to open the connection to SQL Server)"

On the Internet, I can see that others say that they can use the server (local) to replace the localhost of the cost machine, but it still does not work. Then I can reset the IP address myself. The details are as follows:

The following steps require the following prerequisites:

If your sqlserver service has been installed, the server name cannot be found.

　　1. Open the SQL server Management Configurator

Alternatively, enter SQLServerManager10.msc in the command line.

2. Click MSSQLSERVER protocol and select TCP/IP protocol on the right-side page.

3. Right-click the TCP/IP protocol and select "properties". You need to modify the port address for connecting to the database.

4. In the displayed dialog box, there are many TCP/IP ports. Find "IP3" and change the IP address to the IP address of your computer (or 127.0.0.1) to add 1433 to the TCP port, then select start

5. Change all ports of "IPALL" to "1433"

6. Restart the service.

7. Set the port through steps 1-6 above, re-open SQL Server Management Studio, and enter :( local) or 127.0.0.1 in the Server name to log on to the database.

Note: This problem is also encountered when sql2005 was recently installed in the website manager editor. It is solved by referring to this method of modifying ip addresses. Remember to install the SQL 2005 sp3 patch

VS error:

Network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL Server is configured to allow remote connection. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance)

Solution: Start-> SQLServer2005-> Configuration tool-> peripheral application configurator->

Application configurator for service and peripheral connection-> click "remote connection"-> Local Connection and remote connection-> use TCP/IP and named Pipes at the same time-> click" are you sure you want to "-> restart the SQLserver service, but my computer cannot be changed, the peripheral application configurator reports an error message: the change failed. (Microsoft. SqlServer. Smo) Other information: SetEnable fails for ServerProtocol "Tcp. (Microsoft. SqlServer. Smo) I found a solution. My operating system is also win7: Click SQL Server 2005 in SQL Server Configuration Manager to configure the "MSSQLSERVER" protocol, the startup protocol "TCP/IP" and "Name Pipes ". Stop and restart the SQL Server service. You can.