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

This article is to share with you about the solution to the failure of IP connection to SQL SERVER, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Failed to connect to SQL SERVER using IP or configure as a connection string

Scenario 1: when used in webconfig files

To connect to the database, it was found that the login could not be done normally, and there were a lot of errors.

Scenario 2:

Or when connecting to SQL SERVER, enter IP as follows:

Indicates that the connection cannot be made or that the connection is incorrect.

Solution:

Step 1: check whether the TCP/IP protocol is enabled:

On the start menu, find the configuration tool at microsoft SQL SERVER 2005 and click in at the open SQL SERVER Configuration Manager, select the protocol for SQLEXPRESS, and view it at the TCP/IP on the right. If disabled is displayed, double-click it to enable it:

Step 2: select "MSSQLSERVER's Protocol" and also enable "TCP/IP"

Step 3: select its child node "client Protocol" at "SQL Native Client configuration" and see if the "TCP/IP" protocol on the right is enabled. If not, enable it:

Step 4: double-click "TCP/IP Protocol" to view the property panel to see if it is listening on port "1433".

Step 5: finally restart the computer ~ ~ test login ~ successful ~ ~

Attach:

If you find that "local" or "localhost" cannot be used to log in

Solution:

Open the C:\ Windows\ System32\ drivers\ etc path and find the

Hosts file

Then use notepad to open it and see if there are any

The code is as follows:

# localhost name resolution is handled within DNS itself.# 127.0.0.1 localhost

If not, add it below; then restart the computer ~ ~ OK ~ ~

The above is the solution to the failure of IP to connect to SQL SERVER. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.