none
Sql server 2008 mirroring configuration issue RRS feed

  • Question

  • Hi all,

    I have configured SQL server 2008 database mirroring(std edition). It's configured successfully and after adding the witness server in the mirroring ,

    i got the following error,

    Msg 1456, Level 16, State 3, Line 1

    "The ALTER DATABASE command could not be sent to the remote server instance 'TCP://ec2-54-245-233-244.us-west-2.compute.amazonaws.com:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.

    I have verified the following,

    1. I can able to ping between the servers.(A->B->C vs C->B->A)

    2. Verified the Mirroring TCP end point port( here--5022) successfully connected.

    3. I can able to connect the dbserver via sql mgmt studio for all servers.

    4. Verified the Sql port number (1433) among the serves,done successfully.

    Please any one help me on this issue.

    Regards,

    Mahalingam.M


    Thanks, Mahalingamoorthy Marimuthu

    Thursday, November 29, 2012 1:05 PM

Answers

  • Hello,

    On the witness server, run the following command and let us know the output:

    select te.ip_address, te.port, dme.name, dme.role_desc, dme.state_desc, dme.type_desc,dme.connection_auth_desc, dme.certificate_id from sys.database_mirroring_endpoints dme inner join sys.tcp_endpoints te on dme.endpoint_id = te.endpoint_id
    Please obscure yout IP ADDRESS, we don't need it but I included it so that you can double check that your host names are resolving correctly.

    -Sean


    Sean Gallardy | Blog | Twitter

    Thursday, November 29, 2012 1:14 PM
    Answerer
  •  

    Of course the KB is for 2005, but have an look and compare -> http://support.microsoft.com/kb/940254

    Might be your windows OS is not able recognize so try to update the windows host file with IP_ADDRESS_FOR_SERVER SERVER_NAME


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Monday, December 3, 2012 2:32 PM

All replies

  • What is the startup account of the SQL instance used as witness? is it a domain account same as principal/Mirror?

    Does SQL service accounts have connect permission on endpoint? check SQL errorlog on witness, principal for more information about the cause

    Thursday, November 29, 2012 1:13 PM
  • Hello,

    On the witness server, run the following command and let us know the output:

    select te.ip_address, te.port, dme.name, dme.role_desc, dme.state_desc, dme.type_desc,dme.connection_auth_desc, dme.certificate_id from sys.database_mirroring_endpoints dme inner join sys.tcp_endpoints te on dme.endpoint_id = te.endpoint_id
    Please obscure yout IP ADDRESS, we don't need it but I included it so that you can double check that your host names are resolving correctly.

    -Sean


    Sean Gallardy | Blog | Twitter

    Thursday, November 29, 2012 1:14 PM
    Answerer
  •  

    Of course the KB is for 2005, but have an look and compare -> http://support.microsoft.com/kb/940254

    Might be your windows OS is not able recognize so try to update the windows host file with IP_ADDRESS_FOR_SERVER SERVER_NAME


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Monday, December 3, 2012 2:32 PM