While configuring database mirroring we encountered below error message with GUI and in SQL Server Error Log
Error : Database Mirroring login attempt by user ‘Domain\Login’ failed with error: ‘Connection handshake failed. The login ‘Domain\Login’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: xx.xx.xx.xxx]
Reason : Normally this error popup when SQL Server service Account is not added to source (Primary Server) and the account doesn’t have connect permission to mirroring endpoint after adding the account.
Resolution : Add SQL Server Service Account to SQL Server security, GRANT connect permission to the Mirroring endpoint to the User.
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [Domain\Login];