Shulou(Shulou.com)06/02 Report--

The purpose of this article is to share with you the content about how to report an error in building AlwaysOn in SQLServer2012. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

SQLServer 2012 sets up AlwaysOn to report 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.9. [CLIENT: 192.168.1.133]

View the current Endpoint in the master-slave node:

Select * from master.sys.database_mirroring_endpoints

Delete the ENDPOINT of the current master and slave:

USE [master]

DROP ENDPOINT Endpoint_Mirroring

GO

Rebuild the AlwaysOn.

Everything is going well and no more mistakes are reported.

Thank you for reading! This is the end of this article on "how to report errors in SQLServer2012 building AlwaysOn". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.