首页 > 大数据 > ELK > SQLServer2012搭建AlwaysOn报错
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。
一切顺利,不再报错。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69979754/viewspace-2706262/ ,如需转载,请注明出处,否则将追究法律责任。