SQLServer 2012搭建AlwaysOn报错:
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]
在主从节点查看当前的 Endpoint:
select * from master.sys.database_mirroring_endpoints
删除当前主从的 ENDPOINT:
USE [master]
DROP ENDPOINT Endpoint_Mirroring
GO
重建AlwaysOn。
一切顺利,不再报错。