SQL Monitor v7.0 - Issues with SQL Server Monitoring stopped and then starting again at random times
MChantUK
Posts: 3 New member
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:
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
Any help on what could be causing this to occur at all would be appreciated
