none
SQL Server 2005 Mirror RRS feed

  • 問題

  •  

    我有三部電腦(winxp SP2)裝了SQL Server 2005 Standard Edition, 我建立mirror 完全無問題, 可以手動fail over, 但係嘗試加入witness server 就唔得, 請高人指教

     

    三個DB 都有開TestDomain\TestUser account

    無firewall, port is open (telnet ok)

    三個DB verison 9.0.3042

     

    Principal and Mirror Server Endpoint

    CREATE ENDPOINT [endpoint_mirroring]
     AUTHORIZATION [TestDomain\TestUser]
     STATE=STARTED
     AS TCP (LISTENER_PORT = 7022, LISTENER_IP = ALL)
     FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = WINDOWS NEGOTIATE
    , ENCRYPTION = REQUIRED ALGORITHM RC4)

     

    Witness Server EndPoint

     

    CREATE ENDPOINT [endpoint_mirroring]
     AUTHORIZATION [TestDomain\TestUser]
     STATE=STARTED
     AS TCP (LISTENER_PORT = 7022, LISTENER_IP = ALL)
     FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = WINDOWS NEGOTIATE
    , ENCRYPTION = REQUIRED ALGORITHM RC4)

     

    亦有試過 

     

    CREATE ENDPOINT [endpoint_mirroring]
     AUTHORIZATION [TestDomain\TestUser]
     STATE=STARTED
     AS TCP (LISTENER_PORT = 7022, LISTENER_IP = ALL)
     FOR DATA_MIRRORING (ROLE = WITNESS, AUTHENTICATION = WINDOWS NEGOTIATE
    , ENCRYPTION = REQUIRED ALGORITHM RC4)

     

    當我在principal server 輸入

    alter database myTest set witness='TCP://192.168.0.64:7022' 

    或者

    alter database myTest set witness='TCP://witnessServer:7022' 

    或者

    alter database myTest set witness='TCP://witnessServer.TestDomain:7022' 

    結果都係

    The ALTER DATABASE command could not be sent to the remote server instance 'TCP://192.168.0.64:7022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.


    2007年8月3日 上午 01:39

所有回覆