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

This article will explain in detail how to connect to the sql server2008 configuration Mirror Times 1418. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Sql server2008 images have been configured before, but the whole process is actually quite simple, but this time the configuration is really troublesome. Follow the steps to complete step by step. The following error is reported when the image is enabled:

The server network address "TCP://192.168.10.11:5022" is inaccessible or does not exist. Check the network address name and check that the ports of the local and remote endpoints are functioning properly. (Microsoft SQL Server, error: 1418)

It turns out that I didn't install the sql server environment, so I had to check it out slowly:

1. There is no problem with joining domain control. You can use domain users to log in to servers on both sides.

2. Check the port. The port used by the mirror is 5022. There is no problem with using telnet to communicate with each other.

3. In order to miss other ports, I turned off the firewall

Try to open it again, but it's still the same mistake.

In the previous configuration process, I have encountered that the startup user of the primary node is different from that of the mirror node, causing the mirror to fail. Therefore, through the inspection of the configuration center, it is found that the internal accounts of the system are all used:

So I kind of wonder if this is what caused it. I didn't use built-in accounts before. The following error occurred when opening the log of the mirror node:

2017-03-08 19 1815 17.57 Logon Database Mirroring login attempt by user'* * ad\ * 1 $. Failed with error: 'Connection handshake failed. The login' * * ad\ * 1 $'does not have CONNECT permission on the endpoint. State 84.00. [CLIENT: 192.168.room.*]

At first, it is a question of authority, which can basically be solved by changing the startup mode or in accordance with the official authorization.

As soon as you know the problem, change the startup mode to the cost regional account to start. Restart the service, and then turn on the mirror image, problem solved!

This is the end of the article on "sql server2008 configuration Mirror Times 1418 can not be connected". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.