How to monitor Microsoft SQL having Failover Clustering

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
progressive.nagiosXI
Posts: 277
Joined: Mon Jul 31, 2017 5:54 am

How to monitor Microsoft SQL having Failover Clustering

Post by progressive.nagiosXI »

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
You do not have the required permissions to view the files attached to this post.
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: How to monitor Microsoft SQL having Failover Clustering

Post by ssax »

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
Top
Locked

Return to “Nagios XI”