How do you use cloud databases? Take the survey.
Options

SQL Monitor v7.0 - Issues with SQL Server Monitoring stopped and then starting again at random times

MChantUKMChantUK Posts: 3 New member
edited April 12, 2018 9:35AM in Redgate Monitor
Hi

We have been having some issues with the SQL Monitor randomly showing SQL Server authentication failed and then SQL Server authentication successful at random times.

Have checked what we can and cannot see any reason for this at all. Have checked the Logs and found the follwowing:


Message
2018-04-12 03:43:24,495 [106] ERROR RedGate.Response.Engine.Monitoring.Core.Detection.DetectionManager [(null)] - RedGate.Response.Common.Utilities.Status.StatusLoggedException: WMI / OpenNamespace: Root\MSCluster : UnknownError ---> System.Management.ManagementException: User credentials cannot be used for local connections 
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass15_1.<CreateProvider>b__1(Boolean catchException)
   at RedGate.Response.Common.Utilities.Backoff.ExponentialBackoff.Iterate(Func`2 loopAction)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass15_0.<CreateProvider>b__0(String k)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.CreateProvider(String namespaceName)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass14_0.<OpenNamespace>b__0()
   at RedGate.Response.Common.Utilities.Status.StatusLogger.TryLog[T](String groupName, String actionName, Func`1 action, Boolean logSuccess, T& result, RawErrorStatusEvent& rawErrorStatusEvent)
   --- End of inner exception stack trace ---
   at RedGate.Response.Common.Utilities.Status.StatusLogger.Log[T](String groupName, String actionName, Func`1 action)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.OpenNamespace(IStatusLogger statusLogger, String namespaceName)
   at RedGate.Response.Engine.Monitoring.Core.Detection.Detectors.ClusterNodeDetector.Detect(IClusterProvider detectionContext, IStatusLogger statusLogger)
   at RedGate.Response.Engine.Monitoring.Core.Detection.DetectionManager.DetectNodes(IClusterProvider clusterProvider, IStatusLogger statusLogger)
   at RedGate.Response.Engine.Monitoring.Core.Detection.DetectionManager.DetectCluster(Cluster cluster)RedGate.Response.Common.Utilities.Status.StatusLoggedException: WMI / OpenNamespace: Root\MSCluster : UnknownError ---> System.Management.ManagementException: User credentials cannot be used for local connections 
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass15_1.<CreateProvider>b__1(Boolean catchException)
   at RedGate.Response.Common.Utilities.Backoff.ExponentialBackoff.Iterate(Func`2 loopAction)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass15_0.<CreateProvider>b__0(String k)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.CreateProvider(String namespaceName)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.<>c__DisplayClass14_0.<OpenNamespace>b__0()
   at RedGate.Response.Common.Utilities.Status.StatusLogger.TryLog[T](String groupName, String actionName, Func`1 action, Boolean logSuccess, T& result, RawErrorStatusEvent& rawErrorStatusEvent)
   --- End of inner exception stack trace ---
   at RedGate.Response.Common.Utilities.Status.StatusLogger.Log[T](String groupName, String actionName, Func`1 action)
   at RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Wmi.Managed.WmiMachineScope.OpenNamespace(IStatusLogger statusLogger, String namespaceName)
   at RedGate.Response.Engine.Monitoring.Core.Detection.Detectors.ClusterNodeDetector.Detect(IClusterProvider detectionContext, IStatusLogger statusLogger)
   at RedGate.Response.Engine.Monitoring.Core.Detection.DetectionManager.DetectNodes(IClusterProvider clusterProvider, IStatusLogger statusLogger)
   at RedGate.Response.Engine.Monitoring.Core.Detection.DetectionManager.DetectCluster(Cluster cluster)

Any help on what could be causing this to occur at all would be appreciated

Best Answer

Sign In or Register to comment.