Monitoring stopped (Incorrect credentials or insufficient
qcjims
Posts: 38
here is another error:
15 Dec 2010 1:17 PM Registry OpenRegistryHive: LocalMachine Incorrect credentials or insufficient permissions Win32Exception Access is denied
Monitoring was working for a while, then it stopped.
15 Dec 2010 1:17 PM Registry OpenRegistryHive: LocalMachine Incorrect credentials or insufficient permissions Win32Exception Access is denied
Monitoring was working for a while, then it stopped.
Comments
This is data collection error with remote registry. Could you please verify the permission for the user as per this article:
http://www.red-gate.com/supportcenter/C ... 340335.htm
Also, could you please test all the data collection methods are working in your environment.
http://www.red-gate.com/supportcenter/C ... 340335.htm
Regards,
Priya
Project Manager
Red Gate Software
however, why doesn't SQL monitor do these steps and then report on what is/is not actually working?
-jim
Running diagnostics using 3rd party tool enables us to differentiate between problems with SQL Monitor and problems and configuration issues with your windows environment.
SQL Monitor provides fairly detailed error messages on these issue, but sometimes it is unclear what is causing the issue.
On top of this, some windows APIs seem to have transitory issues associated with them.
Let me know if you'd like any further detail.
--
Daniel
There are can be various reasons as why a particular data collection is failing.
If a particular data collection is failing then the first thing I would do is to check whether the account you are using to connect to SQL Server and Machine has required permission or not. Most of the time it doesn't work because the permissions are not correct. You can check the list of permissions here in help file:
http://www.red-gate.com/supportcenter/C ... 340335.htm
Regarding perfmon issue, what exact error message you are getting in 'Monitored servers' page. Could you please click on 'Show log' and send us the error message? Could you also check that the permissions are correct and 'Remote registry' service is running?
Thanks,
Priya
Project Manager
Red Gate Software
I ran through the tests at http://www.red-gate.com/supportcenter/Content?p=SQL%20Monitor&c=SQL_Monitor/help/2.1/SM_Testing_data_collection.htm&toc=SQL_Monitor/help/2.1/toc1340335.htm and they failed at the perfmon step.
I was logging in using user@domain format. When I changed it to DOMAIN\user format it worked...
Don't know why. Anyway, I updated the credentials used for running the SQL Monitor 2 service and restarted it, all my monitors came online.
Hope this helps.