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 |
|
minus4
Starting Member
2 Posts |
 Posted - 2008-02-05 : 14:13:01
|
| HI there,Im setting up database mirroring in MSSQL 2005 standard SP2,i have gone through the process of login, user and certificate for each user for each machine, and copyied them all over and given permissions to the endpoint, however i can never get connected with an error message that wont help:the certificates CN name does not match the passed value!!!!is there anyway to see the passed value ??? what is the passed value?I have double checked to make sure the login name i am using, has a corosponding certificate on the server i am trying to access.Im also using the GUI method, i have tried with transact but when i try to set the command for the mirror, i get an error telling me the datasase is not configured for mirroring, despite the fact that everything is exported and the status on the mirror database is that of recovering.Hope someone can shed some light, maybe even some ideas on getting an output or anythingthanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-05 : 22:38:56
|
| How can you access db that is under recovering? |
 |
|
|
minus4
Starting Member
2 Posts |
Posted - 2008-02-06 : 04:52:50
|
| are you asking a question to me ????if so why? you cant access the recovering database unless you create a snapshot database, but what does this have to do with my question??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:24:44
|
| >> the status on the mirror database is that of recovering. |
|
|
|
|
|
|
sql 2005 standard SP2 mirroring certificates probl