Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring login attempt by user 'domain\SQLLogin' failed Expand / Collapse
Author
Message
Posted Thursday, June 19, 2014 10:49 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:24 AM
Points: 507, Visits: 542
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.
Post #1584149
Posted Thursday, June 19, 2014 10:52 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:24 AM
Points: 507, Visits: 542
I have also granted permission to that login also.

GRANT CONNECT ON ENDPOINT::MirroringEndPoint TO [domain\MySQLAdmin]
Post #1584150
Posted Friday, June 20, 2014 1:38 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:09 AM
Points: 314, Visits: 2,530
Was the account name from domain deleted and recreated ?
Post #1584223
Posted Friday, June 20, 2014 3:24 AM This worked for the OP Answer marked as solution
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:24 AM
Points: 507, Visits: 542
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.
Post #1584250
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse