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 |
|
Pratyus
Starting Member
2 Posts |
 Posted - 2008-08-11 : 04:13:54
|
| I am trying to test the Mirroring concept in my laptop.The OS is Windows Home Premium edition.I installed 2 different instances on my laptop.On Primary instance (Inst1) I created a database(Test).Backed up the database and recovered on the mirrored instance(Inst2) in NO RECOVERY mode.I enabled the TCP/IP and Named instance connection for both the instance and also restarted the instances with TRACE FLAG 1400.Now i configured the INST1 instance to mirror the database to mirrored instance INST2.The Primary is configured to communicate through port 5022 and mirror through 5023.I am using the Windows account for the mirroring service which has got the Admin rights on the box and the server too.When i tried starting the mirroring it gives me the below error message.Error: 1418 - Microsoft SQL Server - The server network address can not be reached or does not exist. Check the network address name and reissue the command. The server network endpoint did not respond because the specified server network address cannot be reached or does not existI tried googling it but did not find any fix for it.Please let me know what am i doing wrong. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-11 : 22:26:07
|
| Tried create server alias with ip address and port number in configuration manager? |
 |
|
|
Pratyus
Starting Member
2 Posts |
Posted - 2008-08-18 : 03:43:40
|
| I got the issue fixed by creating Domain for the users.Thanks for the response. |
|
|
|
|
|
|
Mirror Error coe: 1418