Reply To: SQL AlwaysOn Availability Group – Readable Secondary

Kirs Renaud

Thank you for your reply. Can you please advise if there is a document that outlines exactly what SQL privileges are required as opposed to a global sysadmin role? Our intent is to grant read-access to a single database as opposed to granting access to the HVR user the ability to control the entire SQL installation, including modifying the Availability Group replica to force a failover and become primary.

Thank you

Test drive
Contact us