Sometime you may receive an error in SQL Server's log and Database Mirroring stops:
Database Mirroring login attempt by user ' ' failed with error: 'Connection handshake failed. The login ' ' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: ]
This message actually informs that your security configuration for the mirroring protocol is broken. You can easily rectify this error by fixing the permission on endpoint using below SQL:
GRANT Connect on EndPoint::[EndPoint Name] To [Account]
Below command will fix this issue assuming end point name is “mirroring” and account name used is “ArunL\test”
GRANT Connect on EndPoint::[EndPoint Name] To [ArunL\test]
Note: If your mirroring is suspended then you have to resume mirrirong after this command.
Sometime you may receive an error in SQL Server's log and Database Mirroring stops:
Database Mirroring login attempt by user ' ' failed with error: 'Connection handshake failed. The login ' ' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: ]
This message actually informs that your security configuration for the mirroring protocol is broken. You can easily rectify this error by fixing the permission on endpoint using below SQL:
GRANT Connect on EndPoint::[EndPoint Name] To [Account]
Below command will fix this issue assuming end point name is “mirroring” and account name used is “ArunL\test”
GRANT Connect on EndPoint::[EndPoint Name] To [ArunL\test]
Note: If your mirroring is suspended then you have to resume mirrirong after this command.
