WMI Access is Denied
eastbounddown
Posts: 1 New member
We are setting up a non-admin account to make WMI queries through SQL Monitor. I have followed the WMI guide, and verified that the user has Remote Launch and Activation under the Launch and Activation Permissions Edit Limits of the dcomcnfg on the remote server. The user has Enable Account, Remote Enable, and Read Security permissions under the Root, Cimv2, and MSCluster namespaces under WMI Control of the target servers. From the RedGate servers, I am able to connect with said user to those namespaces, and make queries via the Windows Management Instrumentation Tester, and your Testing WMI Connections Powershell script says the user can do authorised WinRM and DCOM. However, when we attempt it in SQL Monitor, we get the attached error. Any ideas?
Tagged:
Answers
Just updating here from the ticket that was raised where this got sorted out for anyone else who may come across this.
The issue was related to getting the permissions from https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/permissions-required-for-monitoring-servers set correctly on the user being used to connect to the entity (when given domain admin privilege the entities were adding correctly and when reverting to the user there were permissions issues).
Kind regards,
Alex
Have you visited our Help Center?
The page moved in the latest version docs, this link works for v13: https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/adding-servers-for-monitoring/adding-sql-server/permissions-required-to-monitor-sql-server
Kind regards,
Alex
Have you visited our Help Center?