locked
Witness provision Failure (Error Code 1456) for across Data center Mirroring Session RRS feed

  • Question

  • Hello Support,

    We are provisioning Mirroring Session between two SQL Servers in VM hosted in different data centers. as per steps described in TechNet 

    • Principle (East US)
    • Mirror (West US)

    We are able to establish mirroring session successfully. This works fine for manual fail over.

    While establishing automatic fail over and trying to set witness server we are facing following issue on "Alter Database Set Witness ..." statement,

    Msg 1456, Level 16, State 3, Line 1
    The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness_address:witness_port'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.

    Witness Server we had provisioned first in Europe Data center and then in East US also but it fails with above error each time.

    Please not we are able to TelNet the witness server and also able to connect using SQL Server Management Studio from Principal server.

    Please provide us more guide line or suggestions what could be the possibilities and how to rectify the same.

    Regards,

    Ved Yadav



    Friday, July 19, 2013 1:44 PM

All replies

  • Have you verified all there servers listening each other ?

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/faf0a302-c233-4410-8e5f-add056f70cb8/msg-1456-database-mirroring-errror-on-witness

    Go to Windows hosts file and added as following

    Example:

    IP_ADDRESS_FOR_SERVER     SERVER_NAME

    Try perform the following 3 step (Please take notes about the PC IP Address)

    1) In PC [A] try ping PC [B] and PC [C]

    2) In PC [B] try ping PC [A] and PC [C]

    3) In PC [C] try ping PC [A] and PC [C]



    Raju Rasagounder Sr MSSQL DBA

    Monday, June 16, 2014 3:10 AM