A network-related or instance-specific error occurred while establishing a connection with SQL Server. Server _mssql2008 not found or inaccessible

This morning turned on discovery, open SQL Server 2008 SQL Server Management Studio, enter the sa password found, unable to log into the database? Prompts for the following error:

"A network-related or instance-specific error occurred while establishing a connection with SQL Server. The server was not found or could not be accessed. Verify that The example name is correct and that SQL Server is configured to allow remote connections. (provider: Named pipe provider, error:40-None method to open a connection to SQL Server) "

On the internet to see others say the use of the server (local) to replace the cost of localhost, but still not, and then reset their own IP can be . Specifically as follows:

The following steps require a few prerequisites:

Your SQL Server service is already installed, but you cannot find the name .

1. Open SQL Server Management Configurator

or enter at the command line:sqlservermanager10.msc

2, click on the MSSQLSERVER protocol, the right side of the page to select the TCP/IP protocol

3, right click on the TCP/IP protocol, select "Properties", you need to modify the connection database port address

4, jumped out of the dialog box, which has a lot of TCP/IP ports, find "IP3", change the IP address for their own computer IP address (or 127.0.0.1) in the TCP port to add 1433, and then choose to start

5, "Ipall" of all ports to "1433"

6. Restart Service

7, through the above 1-6 steps to set the port, reopen SQL Server Management Studio, in the server name input: (local) or 127.0.0.1, you can log in to the database.

Note: The Cloud Habitat Community Small series recently installed sql2005 also encountered this problem, is to refer to this modification of the IP method to solve. Remember to install the SQL SP3 patch

VS Error:

A network-related or instance-specific error occurred while establishing a connection with SQL Server. The server was not found or could not be accessed. Please verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider:sql network interface, error:26-error locating the specified server/instance)

Workaround: Start the->>sqlserver2005->> Configuration tool->>sqlserver the perimeter application configurator->>

Application configurator for service and perimeter connections->> tap "remote connection"->> local and remote connections->> use TCP/IP and named pipes->> to "OK"->> Restart the SQL Server service but my computer doesn't change, SQL Server perimeter Application configurator reported error message: The change failed. (MICROSOFT.SQLSERVER.SMO) Additional information: Setenable failed for Serverprotocol "TCP". (MICROSOFT.SQLSERVER.SMO) I found a way to solve it. My operating system is also win7: Click the SQL Server 2005 network Configuration "MSSQLSERVER" protocol in SQL Server Configuration Manager to start Protocol "TCP/IP" and "Name pipes". And stop, restart the SQL Server service. Then it's OK.