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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 20, 2015 6:37 AM
Points: 800, Visits: 732
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:
Post #1584149
Posted Thursday, June 19, 2014 10:52 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 20, 2015 6:37 AM
Points: 800, Visits: 732
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:
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, April 14, 2015 10:30 PM
Points: 314, Visits: 2,537
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 20, 2015 6:37 AM
Points: 800, Visits: 732
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:
Post #1584250
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse