Nothing But Failures RRS feed

  • Question

  • I am trying to add an Always On Availability group on SQL Server 2012. No matter what I do I keep getting failures. I am at the point of this error when creating an endpoint:

    Database Mirroring login attempt by user 'domain\machinename$.' failed with error: 'Connection handshake failed. The login 'domain\machinename$' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: XXX.XXX.XXX.XXX]

    When I try to give permissions I get this error:

    grant connect on endpoint::Hadr_endpoint to [domain\machinename$]

    Msg 15151, Level 16, State 1, Line 1
    Cannot find the login 'domain\machinename$', because it does not exist or you do not have permission.

    My understanding is that this is supposed to be relatively easy. So far that is not the case.

    I already read the suggested link you're probably going to post about mirroring. This did not help. I need a solution for this ASAP

    Tuesday, April 12, 2016 8:23 PM


All replies