Shulou(Shulou.com)06/03 Report--

This article shows you how to solve the problem that SQLServer 2017 can not connect to the server. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Installed the database several times, but also due to the subsequent manual modification of the computer IP port and even the host name and so on, resulting in Sql sever can not connect errors, this note records this heavy history in case of a rainy day.

The reason for this time is that the default name of the host has been changed (disabled hands during the winter vacation, only 7 weeks after I went back to school to use SQL, but the goose has long forgotten why)

Mistakes such as the above, which should be solved according to the online tutorial, should be ok.

Method one

Is to open these things in the service.

Especially the SQL Server agent

Method two

1. Open Sql server Management Configurator

Or enter: SQLServerManager14.msc on the command line

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

3. Right-click the TCP/IP protocol and select "Properties". You need to modify the port address that connects to the database.

4. A pop-up dialog box with many TCP/IP ports, find "IP3", change the IP address to the IP address of your computer (or 127.0.0.1), add 1433 to the TCP port, and then choose to start (but all the 1433 ports that have been installed successfully and have run the database have been added)

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

6. Restart the service and connect

(use the steps 1-6 above to set up the port, reopen SQL Server Management Studio, and log in to the database by entering the server name: (local) or 127.0.0.1 (this is for choosing to establish a connection that is not your account).

Method three

Open the SQL Server Management console

It's not as troublesome as the second step.

Open the TCP/IP on the right

Method 4

Check for solutions to problems caused by firewall prohibitions

Method five

Because the host name is incorrect (stolen)

Originally, my host name is the number in this circle by default of Lenovo.

But I think this code is so boring that I changed my Chinese name.

Then when the connection was established, the server did not recognize it.

(then I never realized this problem, because it was three months ago that I changed the name of my computer. I just remembered that my computer seemed to have changed its name.)

Find your device name and change it to the corresponding name when connecting to the database.

(at present, I have only used this method, after all, my hand is disabled, and I haven't figured it out for a long time, so I laugh at myself. At the same time, give a reminder that the cause of the error is not necessarily due to its hints or some conventional ones. If there are errors that cannot be solved, it is best to consider whether they are caused by modifying other data.)

The above content is how to solve the problem that SQLServer 2017 can not connect to the server. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to 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.