Simple Script for Permissions Required

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?

Dustin Halvorson October 18, 2022 03:25

Comments

1 comment

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

Alex B October 19, 2022 16:32

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Simple Script for Permissions Required

Comments

Add comment