Gives following error:
Database Mirroring login attempt by user ‘XXXX\YYYY$.’ failed with error: ‘Connection handshake failed. The login ‘XXXX\YYYY$’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: 172.19.5.144]
Need to grant permission to account which is failing to connect as per message in Errorlog.
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [login_mirroring]