SQLServer映象報錯Connection handshake failed

ywxj_001發表於2019-12-12

圖形化建SQLServer映象報錯:

SQLServer映象報錯Connection handshake failed

資料庫日誌:

Database mirroring connection error 5 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'


檢視主從映象內容:
select * from sys.database_mirroring_endpoints
只有兩邊的name不同。
打算重建映象:
主從依次執行以下SQL:
刪除語句:
DROP ENDPOINT [Endpoint_Mirroring]
重建語句:
CREATE ENDPOINT [Endpoint_Mirroring]
STATE = STARTED
AS TCP(LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ENCRYPTION = REQUIRED ALGORITHM RC4, ROLE = ALL)

GO


再用影像化重建映象完成正常:

SQLServer映象報錯Connection handshake failed


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2668367/,如需轉載,請註明出處,否則將追究法律責任。

相關文章