6

I successfully created a mirror with certificates between two servers. One of those servers was a domain controller. After removing the domain the mirror was interrupted. After hours of searching I reinstalled SQL Server hoping all possible domain removal issues would be gone, but still the mirror refuses to work. I keep getting the vague error:

Msg 1418, Level 16, State 1, Line 1 The server network address "TCP://..." can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

If I check the eventlog of the mirrorserver I see 2 errors:

  1. A cryptographic operation failed. This error indicates a serious problem with SQL Server. Check the SQL Server error log and the Windows event logs for further information.
  2. A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error '5(failed to retrieve text for this error. Reason: 15105)'.

Any ideas/suggestions?

Improve this question

1 Answer 1

Reset to default
6

After days of searching, I found the answer 10 minutes after this post. The problem was that the admin account did not have read/write rights on c:\ProgramData\Microsoft\Crypto\RSA\MachineKeys\ . After changing that I also had to recreate the master keys and certificates to make it work.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.