Logon SQL Server2008 An error was not found or was inaccessible to the server, and a network-related or instance-specific error occurred. Verify that your instance name is correct and that SQL Server is configured to allow remote connections

I do not know what the reason, the log-in database today, this error may be related to my previous installation of MySQL, just started to think it was password input errors, tried several times or not resolved. Finally wait for you, haha, in this URL http://www.2cto.com/database/201405/300620.html see solution, now carry over, also is convenient under everybody ~ Plus, attach another blog, speak sql Server2005 The same problem-solving method: Http://blog.csdn.net/wyodyia/article/details/4795101

Today open SQL Server 2008 SQL Server Management Studio, enter the password discovery for SA, unable to log on to the database, prompting information such as:

Solution:

1. Open SQL Server Management Configurator

or enter at the command line: sqlservermanager10.msc

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

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

4, jump out of the dialog box, there are many TCP/IP ports, find "IP3", change the IP address for their own computer's IP address (or 127.0.0.1) on the TCP port add 1433, and then click Apply

5, modify the "IPALL" all the ports to "1433" (or this interface, pull down the scroll bar)

6. Restart the service

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

Logon SQL Server2008 An error was not found or was inaccessible to the server, and a network-related or instance-specific error occurred. Verify that your instance name is correct and that SQL Server is configured to allow remote connections