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
- SQLServer2012對現有AlwaysOn群集新加節點SQLServer
- 完美解決SqlServer2012啟動報錯(cannot find one or more components.Please reinstall the application。)SQLServerAPP
- SQLSERVER2012備份日誌報錯:”讀取失敗: 23(資料錯誤(迴圈冗餘檢查)。)”SQLServer
- SQLServer2012備份事務日誌報錯:讀取失敗: 1(函式不正確。)SQLServer函式
- SQLServer建立AlwaysOn加副本報錯:副本之間的端點資料加密配置不相容SQLServer加密
- idea maven搭建spring報錯:No bean named 'xxx' availableIdeaMavenSpringBeanAI
- Flutter 安裝搭建報錯 Android sdkmanager tool not foundFlutterAndroid
- SQLServer搭建域控下映象報錯Connection handshake failedSQLServerAI
- SQLServer2012 logshipping實施方案SQLServer
- Kafka安裝搭建、常見報錯、常用命令Kafka
- 在 centos6.9 上 cdh-5.13.3的搭建報錯CentOS
- Windows下hadoop環境搭建之NameNode啟動報錯WindowsHadoop
- oracle 19c dg搭建duplicate過程中報錯Oracle
- SQLServer2012評估期已過SQLServer
- SQLServer2012刪除表欄位SQLServer
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_replicasAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_groupsAI
- 搭建備庫時報錯“ORA-00203: using the wrong control files”
- [AlwaysOn2017] AlwaysOn的DMV和DMF -sys.availability_databases_clusterAIDatabase
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_cluster
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_groups_clusterAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_group_listenersAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_tcp_listener_statesTCP
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_cluster_networks
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_cluster_members
- [AlwaysOn2017] AlwaysOn的DMV - Sys.dm_hadr_availability_replica_cluster_statesAI
- JavaScript報錯型別(報錯速查)JavaScript型別
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_name_id_map
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_instance_node_map
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_database_replica_statesDatabase
- [AlwaysOn] 建立SQL Server AlwaysOn高可用性組T-SQL語法SQLServer
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.fn_hadr_distributed_ag_replica
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.availability_read_only_routing_listsAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_auto_page_repairAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_availability_group_statesAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF - Sys.dm_hadr_availability_replica_statesAI
- [AlwaysOn2017] AlwaysOn的DMV和DMF -Sys.availability_group_listener_ip_addressesAI