Nagios Support Forum

Hi Team,

we are facing problem in monitoring MSSQL Database containing clustering like primary,secondary ,replica of secondary server.

Please help how to monitor such type of infrastructure

showing below error :

(17892, "Logon failed for login 'SPRO0316_RO' due to trigger execution.DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed

Please help!!
Thanks

Logon failed for login 'XXXXXX' due to trigger execution

You will need to work with your SQL Server DB administrator to investigate why their logon trigger is failing, please see here for more information:

https://blog.sqlauthority.com/2009/06/2 ... to-master/

Thank you