High availability architecture for SharePoint Farm with SQL Server Always on Availability Group-grant permission to account
Recently, I have been working with High availability architecture for SharePoint Farm with SQL Server Always on Availability Group as shown in below diagram.
Gives following error:
Database Mirroring login attempt by user ‘XXXX\YYYY$.’ failed with error: ‘Connection handshake failed. The login ‘XXXX\YYYY$’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: 172.19.5.144]
Need to grant permission to account which is failing to connect as per message in Errorlog.
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [login_mirroring]
"Success is a lousy teacher. It seduces smart people into thinking they can't lose."
(Bill Gates-Cheif Software Architect,Microsoft)
Energy For Software Development Blog
Beware. It is not a Socialist Idea. It is a Think Tank creation Idea. Thank. Area: Human as Machine
For: The Bill & Melinda Gates Foundation
on The Future of Development Assistance