SQL Server 2012(11.0.3000) 奇怪的資料庫鏡像精靈 bug

見證伺服器的 Mirror Port 的加密演算法是 RC4 與其他角色採用的 AES 不同,但有些機器又不會

精靈為鏡像伺服器建的 Mirror Port 叫 Hadr_endpoint,個人猜測是為 SQL 2012 Available Group 調整

image 

實際產生的語法:

USE [master]
GO

/****** Object:  Endpoint [Hadr_endpoint]    Script Date: 2014/2/13 下午 02:00:21 ******/
CREATE ENDPOINT [Hadr_endpoint]
    STATE=STARTED
    AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
    FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM AES)
GO

但為見證伺服器提供的步驟則與舊版相同

image

CREATE ENDPOINT [鏡像]
    STATE=STARTED
    AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
    FOR DATA_MIRRORING (ROLE = WITNESS, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
GO

砍掉,重新建立就可以了

CREATE ENDPOINT [鏡像]
    STATE=STARTED
    AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
    FOR DATA_MIRRORING (ROLE = WITNESS, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM AES)
GO

否則會與 Witness 無法溝通

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: