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部落格 ” ,連結:http://blog.itpub.net/69979754/viewspace-2706262/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLServer2012搭建AlwaysOn報錯:Certificate not found. State 89SQLServer
- SQL Server AlwaysOn搭建SQLServer
- SQLServer2012對現有AlwaysOn群集新加節點SQLServer
- SQLSERVER2012備份日誌報錯:”讀取失敗: 23(資料錯誤(迴圈冗餘檢查)。)”SQLServer
- SQLServer2012備份事務日誌報錯:讀取失敗: 1(函式不正確。)SQLServer函式
- SQLServer建立AlwaysOn加副本報錯:副本之間的端點資料加密配置不相容SQLServer加密
- Flutter 安裝搭建報錯 Android sdkmanager tool not foundFlutterAndroid
- oracle 19c dg搭建duplicate過程中報錯Oracle
- Kafka安裝搭建、常見報錯、常用命令Kafka
- 在 centos6.9 上 cdh-5.13.3的搭建報錯CentOS
- SQLServer搭建域控下映象報錯Connection handshake failedSQLServerAI
- Windows下hadoop環境搭建之NameNode啟動報錯WindowsHadoop
- 新搭建的mysql登陸報錯mysql Segmentation fault (core dumped)MySqlSegmentation
- Sqlserver 2014 主從兩節點用指令碼完成alwayson搭建SQLServer指令碼
- JavaScript報錯型別(報錯速查)JavaScript型別
- lnmp環境搭建好後,,,,解析php檔案報錯 502LNMPPHP
- 如何遷移Alwayson AG
- idea maven搭建spring報錯:No bean named 'xxx' availableIdeaMavenSpringBeanAI
- 直播平臺搭建,elementui的導航路由遞迴報錯解決UI路由遞迴
- iOS 搭建XMPP環境時新增依賴庫報錯及解決iOS
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_replicasAI
- [AlwaysOn] 建立SQL Server AlwaysOn高可用性組T-SQL語法SQLServer
- JavaScript報錯JavaScript
- spark報錯Spark
- mybatis報錯MyBatis
- redis報錯Redis
- 報錯+2
- playsound報錯
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_tcp_listener_statesTCP
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_groupsAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_group_listenersAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF -sys.availability_databases_clusterAIDatabase
- [AlwaysOn] AlwaysOn可用性組的可用性模式之間的差異模式
- springcloud報錯報UnsatisfiedDependencyExceptionSpringGCCloudException
- asm報錯一例-support 報錯rename failedASMAI
- SQL Server Alwayson概念總結SQLServer
- 丐版sqlserver AlwaysOn叢集SQLServer
- SQLServer2012評估期已過SQLServer