Shulou(Shulou.com)05/31 Report--

This article will explain in detail about SQL Server connection server error solution, the quality of the article content is high, so Xiaobian share for everyone to make a reference, I hope you have a certain understanding of related knowledge after reading this article.

Open SQL Server 2008 SQL Server Management Studio, enter sa password found, unable to log in to the database? The following errors are noted:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server could not be found. 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 connection to SQL Server)"

Specific solutions are as follows:

Open SQL Server Management Configuration Manager.

Or at the command line type: SQLServerManager10.msc

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

3. Right-click TCP/IP protocol and select "Properties" to modify the port address of the connection database.

4, jump out of the dialog box, there are a lot of TCP/IP ports, find "IP3", change the IP address to your computer's IP address (or 127.0.0.1) Add 1433 in TCP port, and then select Start

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

6. Restart the service

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

About SQL Server connection server error solution to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.