Operation on handle \\server\HKEY_LOCAL_MACHINE failed

hespinozahespinoza Posts: 7 New member
edited January 30, 2013 7:13PM in SQL Monitor Previous Versions
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]..[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.

Comments

  • 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/c ... 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
Sign In or Register to comment.