Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EetieD
Starting Member
5 Posts |
 Posted - 2008-09-24 : 09:11:26
|
| Hello,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.EetieD. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-24 : 15:00:22
|
| Did you restore full and log backup in NORECOVERY mode in secondary server.Look at this:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=334710&SiteID=1 |
 |
|
|
|
|
|
database mirroring problem