Database Mirroring login attempt by user 'domain\SQLLogin' failed

  • Got this error suddenly but mirroring is happening absolutely fine. Also the login 'domain\MySQLLogin' is no where related to mirroring.

    Database Mirroring login attempt by user 'domain\MySQLLogin' failed with error: 'Connection handshake failed. The login 'domain\MySQLLogin' does not have CONNECT permission on the endpoint. State 84.'.

    Could somebody give an idea on this. The eventlog is getting full for every second because of this error.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

  • I have also granted permission to that login also.

    GRANT CONNECT ON ENDPOINT::MirroringEndPoint TO [domain\MySQLAdmin]

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

  • Was the account name from domain deleted and recreated ?

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

  • No, the domain name was not deleted.

    The issue got solved when I removed the SQL Login and added and gave permission in mirror server and witness server. 🙂

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

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

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