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 |
|
DaveC11
Starting Member
43 Posts |
 Posted - 2009-02-03 : 05:39:24
|
| Hi I'm having a problem trying to set up a mirrored DB on a virtual network. I've virtual servers sat on a vertual demain. I'm trying to set one as my principle server, one as the mirror and the last one as the witness. All three servers are running SP1. Everything works fine setting up the mirroring using the wizzard but when I click start mirroring I get the below message. Any ideas??the server network address "tcp://sql2.ho.sqltest.com:5022" can not be reached or does not exsist. error number 1418 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 09:28:18
|
| What edition of SQL Server 2005 you are using for principal and Mirror ? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-03 : 12:54:55
|
| check this out - http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-02-03 : 13:30:33
|
| I remember when I did this, it gave a similar error as a sort of catch-all error. Did you take a log backup of the principal, and apply it to the mirror? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 23:55:36
|
quote:
Originally posted by mcrowley
I remember when I did this, it gave a similar error as a sort of catch-all error. Did you take a log backup of the principal, and apply it to the mirror?
In NO-RECOVERY MODE. |
|
|
|
|
|
|
DB mirroring in SQL Server 2005