Simple Script for Permissions Required

SternalLime626

I've only started using the product, but I've already noted there is a laundry list of permissions needed from both the SQL end and the Windows Server end in order to get the product working.  When adding in the thought of least priv, this looks to be almost an impossible task to get right everything single time. 

Has anyone created a script, or a very simple task list to execute on a server to allow the monitoring to function without providing it things like local admin / sysadmin permissions?

Alex B

Hi @SternalLime626,

All of the privileges needed are listed on https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/permissions-required-for-monitoring-servers under the two sections "Monitoring host Windows machines without admin permissions" and under the note in the "Monitoring SQL Server instances" section talking about not being able to use sysadmin.  Most of them are already in script form, though it does not have a script for the WMI namespace and DCOM Remote permissions or adding users to groups.

Kind regards,
Alex