Sqlserver2012 AlwaysOn error


Sqlserver 2012 AlwaysOn reported an error:

Database Mirroring login attempt failed with error: ‘Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.’. [CLIENT:]

View the current in the master-slave nodeMobile GamesEndpoint:

select * from master.sys.database_mirroring_endpoints

Delete the current master-slave endpoint:

USE [master]

DROP ENDPOINTwww.diuxie.com Endpoint_Mirroring


Rebuild AlwaysOn.