Server Credentials
johnt@checksforless.com
Posts: 5
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
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
Comments
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
Project Manager
Red Gate Software
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