June 19, 2014 at 10:49 pm
Got this error suddenly but mirroring is happening absolutely fine. Also the login 'domain\MySQLLogin' is no where related to mirroring.
Database Mirroring login attempt by user 'domain\MySQLLogin' failed with error: 'Connection handshake failed. The login 'domain\MySQLLogin' does not have CONNECT permission on the endpoint. State 84.'.
Could somebody give an idea on this. The eventlog is getting full for every second because of this error.
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂
June 19, 2014 at 10:52 pm
I have also granted permission to that login also.
GRANT CONNECT ON ENDPOINT::MirroringEndPoint TO [domain\MySQLAdmin]
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂
June 20, 2014 at 1:38 am
Was the account name from domain deleted and recreated ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 3:24 am
No, the domain name was not deleted.
The issue got solved when I removed the SQL Login and added and gave permission in mirror server and witness server. 🙂
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply