Sqlserver2012 AlwaysOn error

Time:2021-8-25

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: 192.168.1.133]

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

GO

Rebuild AlwaysOn.