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 |
|
AJITH123
Starting Member
5 Posts |
 Posted - 2007-01-08 : 23:40:56
|
| I installed sql 2005 (server) in two Win-Xp machines and tried to access each other, it was working fine, after that I tried to mirror the data base (I already installed SP2 in both machine) then I am getting an error saying,"A connection was successfully established with the server, but then an error occured during the preloging handshake.(provider SSL,error:0 - The certificate chain was issued by an authority that is not trusted.)(microsoft SQl Server)" After that I could not connect the the sql remot. If any body knows the slution pls reply me.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-09 : 13:03:47
|
| what version? since u installed on XP i'm guessing that u installed express or developer?mirroring is only supported on standard and enterprise |
 |
|
|
AJITH123
Starting Member
5 Posts |
Posted - 2007-01-11 : 04:35:21
|
| I installed the Enterprise version in both machines!!I can able to get the wizard for creating the mirror at the last (Finish) step, and then I am getting the error mentioned above. After that i could not connect the machine each other. Also one more thing, I installed the sql server with default instance in one machine and the other machine having an instance name, whether this will puul out the error ?Thanks |
|
|
|
|
|
|
Problem with remote SQL access