SQL Server Performance Forum – Threads Archive
Problem with MirroringHi,
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.
r u using encryption in your db. Madhu
No, I am not using any encrypted objects!!
However I am trying to connect the server which has different instance name (One is installed in Default instance, and the other is with an instance name), whether this is reason for the problem ? Thanks
if you have enabled FORCE PROTOCOL ENCRYPTION then disable it, refer to KBAhttp://support.microsoft.com/kb/276553 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.