Thread: database mirroring problem
09-24-08, 09:57 #1Registered User
- Join Date
- Aug 2008
Unanswered: database mirroring problem
I got some big problems while trying to set database mirroring, which is the following:
An error occurred while starting mirroring.
The server network address "xx.xxx.xxx.xxx:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
I have two (VMWare) virtual machines, and each of them I installed an instance of the SQL Server, with exactly the same databases. I would like to use one of them as my mirror server.
I tried to set up database mirroring from the button "Configure Security" in the "Mirroring" tab. Fortunately, I haven't got problems during the wizard "Configure Security". I can choose not to use a witness server, and I can connect to the other SQL Server on the other virtual machine (as mirror).
While starting mirroring, the problem exists, as seen on the top. What am I doing wrong?
I tried to ping from the virtual servers to the other virtual machine. I cannot find any problem while doing this. I also opened some ports in the Windows Firewall (although the Firewall is set to off). The recovery model is also set to 'FULL'.
I hope someone can help me. I already tried many many times, and any help would be highly appreciated! Thanks.
09-24-08, 12:45 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Make sure that the service accounts for SQL Server services on the machines involved in the mirroring are explicitly granted the CONNECT permission on the database mirroring endpoints."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."