question

SenadSadikovic-6569 avatar image
0 Votes"
SenadSadikovic-6569 asked Crystal-MSFT commented

Microsoft.SQLServer.Windows.Module.Monitoring.Monitors.SecurablesConfigMonitor

Hi,

I'm getting some annoying SCOM alerts on SQL Server Monitoring MP Windows for some module that fails from time to time and i cant figure this one out, can anybody help here? Doesnt seem to execute some workflow:

Module: Microsoft.SQLServer.Windows.Module.Monitoring.Monitors.SecurablesConfigMonitor
Version: 7.0.20.0

Error(s) was(were) occurred:
Message:
---------- Exception: ----------
Exception Type: System.InvalidOperationException
Message: Instance failure.
Source: System.Data
Stack Trace:
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, Boolean isFirstTransparentAttempt, SqlAuthenticationMethod authType, Boolean disableTnir, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover, Boolean isFirstTransparentAttempt, Boolean disableTnir)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.TransientErrorHandling.SqlRetryClient.<GetNewOpenedConnectionInternalAsync>d_38.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.TransientErrorHandling.SqlRetryClient.<InitConnectionAsync>d
39.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.TransientErrorHandling.SqlRetryClient.<ExecuteCommandDataReaderInternalAsync>d
37.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.TransientErrorHandling.SqlRetryClient.<ExecuteCommandDataReaderAsync>d
32.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Core.Module.Helper.Monitoring.SecurablesConfigMonitorBase.<GetPropertyBagAsync>d
9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.Base.DataItemHelper.<GetPropertyBagDataAsyncStatic>d
_5`1.MoveNext()

msc-operations-manager
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SenadSadikovic-6569 , From the information you provided, I find the alert seems to come when it is unable to connect SQL instance with Instance failure. To clarify our issue, could you let us know if all the SQL instance can be connected with Microsoft SQL server Management Studio.

Meanwhile, check the Operations Manager event log to see if there's any other findings.

On the other hand, check if the SQL is working well in our environment.

If there's any update, feel free to let us know.

0 Votes 0 ·

@SenadSadikovic-6569 , Hope things are going well. I am writing to see if there's an opportunity to check the above information, If there's any update, feel free to let us know.

0 Votes 0 ·

Hi, sorry for the late answer.

Yes it i can connect to the SQL instance via Management Studio, havent felt any issues there.

I think the Operations log is logging the above error message but i can verify it again just to be safe.

I dont know that the SQL is workling poorly,

0 Votes 0 ·
Show more comments

Here are screenshots from the event on the SQL server:

95485-sql1.png95591-sql.png


0 Votes 0 ·
sql1.png (234.1 KiB)
sql.png (213.2 KiB)
Show more comments

1 Answer

SenadSadikovic-6569 avatar image
0 Votes"
SenadSadikovic-6569 answered Crystal-MSFT commented

Problem vanished by itself after i appended some updates to SCOM with UR 3 and updated the SQL MP:s

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SenadSadikovic-6569, Thanks for the reply. I am glad to hear the issue is resolved by upgrading SCOM to UR3 and updating SQL MPs. Congratulations! Thanks for sharing here. It can help others who has the same issue. I appreciate it.

Again thanks for your time and have a nice day!

0 Votes 0 ·