Post reply

database mirroring connection handshake failed

  • May 9, 2015 at 9:35 am

    #300439

    I configured a database mirroring on SQL server 2008 R2 on test environment. However It was not working, after some time. I deleted the mirroring configuration and also deleted database on both primary and mirror instance.

    few days later I notices, On Primary, Continuous error events logged with message "database mirroring attempt by user 'domain\service account' failed with error 'connection handshake failed, 'domain\service account' does not have permission on the endpoint state 84.

    I want to get rid of this message. Your suggestions are much appreciated

  • May 12, 2015 at 3:53 am

    #1797198

    Hi,

    Check to see if the mirroring endpoint still exists and drop it if it does

    DROP ENDPOINT endPointName

    Matt

  • May 12, 2015 at 6:56 am

    #1797249

    Yes.

    There was end point exist. I dropped the endpoint. The issues is solved

    Thanks Matt,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply