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:
- 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.
- 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? I'm getting desperate here!