High availability architecture for SharePoint Farm with SQL Server Always on Availability Group-grant permission to account

July 31, 2018

Case:
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]

Solution:
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]
GO

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-allow-network-access-windows-authentication?view=sql-server-2017

Advertisements