Operation on handle \\server\HKEY_LOCAL_MACHINE failed

[hespinoza]

We recently change the account our sql red gate service is running under and after that change we are having problems starting the monitoring of our servers. Below is the entry of our log file that gets written when we try to reestablish the connection to the servers

2013-01-29 22:46:01,822 [ 5] WARN RedGate.Response - Getting Log file
2013-01-29 22:47:07,601 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.Licensing.LicenceAllocator - Licence level for uldbprod (1) changing from #a to #b
2013-01-29 22:47:07,625 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-29 22:47:07,716 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\server\HKEY_LOCAL_MACHINE failed with error 5. Closing handle.

Any ideas of what this would possible be?

Thanks.

[stanori]

Hi hespinoza,

Thanks for your post. It looks like there could be some issues with remote registry access. From the machine that is running the SQL Monitor Base Monitor service you can log in with the new account you changed to, and run through the following data collection tests:

http://www.red-gate.com/supportcenter/content/SQL_Monitor/help/3.2/SM_Testing_data_collection

It could be this account does not have proper rights to the remote registry. Hope this helps.

Best Regards,
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378