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 ENDPOINTwww.diuxie.com Endpoint_Mirroring
GO
重建 AlwaysOn。