Server Credentials

johnt@checksforless.com

Good Day,

I'm attempting to setup a new Monitored Server and am having trouble troubleshooting a permissions issue. I am currently using a domain admin account that is also an administrator on the SQL Server database. I am getting an insufficient permissions error but can't tell which area the error is coming from. In the error log I see

Group - WMI
Event - OpenNamespace: root\cimv2
Exception - UnauthorizedAccessException
Message - Access is denied. HRESULT: 0x80070005

Thanks,
John

priyasinha

Hi John,

This error is coming because the WMI queries are failing. The credentials which you are using to connect to the machine hosting this SQL Server instance, needs to an administrator on the machine.

Please check this help link regarding the permission you need to connect to the monitored server.

http://www.red-gate.com/supportcenter/C ... %20Monitor

Also, in case you see any other connection error, you can try this simple tests to see if all the data collection is working as expected:

http://www.red-gate.com/supportcenter/C ... 269935.htm

Thanks,
Priya

johnt@checksforless.com

I've tried using both Domain Admins and a user on the box who is a system Admin.

Going through troubleshooting on a WMI site I think the issue is with UAC being active on the machine. I have to wait for the machine to be rebooted next to confirm but I'll post if that seems to be case.

John