SQL Server – Database Endpoint not working after server restart

Issue : After window server restarted database mirroring is stop working, Mirroring endpoint was broken and getting connection handshake failed.

Troubleshooting checklist

  1. Checked SQL Server error log on principal server

Database Mirroring login attempt failed with error: ‘Connection handshake failed. The certificate used by this endpoint was not found: Certificate expired. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State 85.’

Restarted endpoint

ALTER ENDPOINT mirroing STATE= stopped

ALTER ENDPOINT mirroing STATE= started

Leave a Reply

  

  

  


+ 3 = 7