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

It is believed that many inexperienced people have no idea about how to deal with the specified server error. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Today, my colleague asked to build a user, which was built according to the old rules and minimized authorization.

Problems arise

My colleague said that I could not visit. From the point of view of the local inspection, there was no problem with the visit. I felt very strange.

Login access, there is no problem logging in normally.

However, when accessing through a different client, there is no access to it.

Through self-verification, it is indeed inaccessible.

Even on the native machine, the ip+ instance name cannot be accessed, and the same instance name error prompt appears. I didn't install and deploy this library, so it feels very strange.

Check for errors

Check the network configuration and port, and there is nothing wrong, as follows:

Judging from the details, I don't see any problem.

Through the slave telnet 1433 port, it is also impassable.

From here, there is something wrong with the port.

3. Check on the server

It is strange that there is a port 1433 that accesses others, but there is no port 1433 of its own. You can query it as follows:

Exec sys.sp_readerrorlog0, 1, 'listening'

Finally found out, the problem is here, the use of port 51046, no wonder you can not log in.

The same is true of the original configuration.

During the first inspection, I didn't notice this. I thought it was like this in the interface of the agreement. It was sad.

4. After knowing the problem, you will know how to log in, and log in smoothly. Pay attention to the writing with port.

After reading the above, have you mastered the method of locating what is wrong with the specified server? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.