Home Forums SQL Server 2008 SQL Server 2008 High Availability SQL Server Mirroring Issue RE: SQL Server Mirroring Issue

  • September 19, 2017 at 1:47 am

    #1959904

    Arsh - Tuesday, September 19, 2017 1:30 AM

    Can u check this without witness ? to narrow down to any issue with the witness .  Also , make sure you use the same user (preferably , AD account) at both the primary and secondary SQL servers as service accounts  and they have appropriate permissions.

    Thanks for the reply, I tried starting Mirroring without Witness Server also but the same error occurred in Principle and Mirror Server.
    And I am using same Domain User in all 3 servers and in all 3 SQL server Instances Domain User is assigned as SYSADMIN.
    I am getting error  in Mirror server as "Handshake Failed, the login does not have connect permission on the endpoint. State 84"
    But when I am trying to grant connect permission on the endpoint to the Domain User it sends the error "cannot grant, deny or resolve permission to sa, dbo, entity owner, information schema, sys, or yourself.
    I am stuck here badly.