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

This article mainly introduces the Sql server port does not open the connection can not do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Solution

1. Open sql server configuration manager to check whether the two items on the diagram are in running status.

two。 Then check whether these two items are Enable. I tried many times before, but I only set TCP/IP to Enabled, but it never worked. Later, I saw in a post that I also wanted to set Name Pipes to Enabled. I changed it, and then I got better, but I don't know if it's because of this. Anyway, I just set it up.

3. Then double-click the ECP/IP option to go to the properties page and fill in the IP address as the address of server. TCP Dynamic Ports remains 0, TCP Port is set to 1433, and set to 1433 as if because the default port of sql server is 1433 or something.

Then scroll to the bottom, and the TCP Port in the IPALL tab is also set to 1433 IPALL Dynamic port, which is automatically set.

Then turn off the TCP/IP property, open the following option, set it as shown, and set this to 1433.

Then go to Control Panel-- > system and Security-- > Management tools-- > Services, and restart these two services (I hear it's very important).

Let's stop here today. It's already ten o'clock. I have to take the subway home. I enjoy working late every day and come home and sit on the subway. I feel very warm. I'll write it tomorrow.

I wrote here yesterday and continue today. Where did I talk about last time? Oh, Yin Zhiping was about to take off Xiao Longnu's white silk. no, no, no. Ahem. Ahem. I mean, if you want to check which ports of sql server on a machine are listening, you can first log in to sql server with windows authentication, and then use the following statement to query

-- query port numbers exec sys.sp_readerrorlog 0, 1, 'listening'

Well, the query result looks like this. Well, the query result below means that the port you are listening to is 5419. Do you understand?

This is the listening port number of the native sql server. If you want to query which port of the sql server on the server is listening, you need cmd-- > telnet IP Port (ex: telnet 192.138.138.138 1438). If this port is listening, it will jump to a window with a black screen, and the window title bar will show the IP of the server you viewed. All right, that's it. I can't remember anything else. Break up the meeting!

Thank you for reading this article carefully. I hope the article "what to do if the Sql server port is not open and connected" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.