Search found 4 matches

by tsample
Thu Sep 19, 2024 10:59 am
Forum: Nagios XI
Topic: MSSQL Monitoring Issue
Replies: 5
Views: 5428

Re: MSSQL Monitoring Issue

Update: I escalated this to a support ticket. Bug report was generated for the MSSQL plugin as it doesn't work currently for 2012 SQL servers. 2016 SQL servers and above worked fine in our testing.

This thread can be closed.
by tsample
Wed Aug 28, 2024 2:28 pm
Forum: Nagios XI
Topic: MSSQL Monitoring Issue
Replies: 5
Views: 5428

Re: MSSQL Monitoring Issue

No error logs on MSSQL side for connection attempts.

I did double check and the SQL server properties is set to use local and windows authentication. I tried doing both and still had the same issue.
by tsample
Wed Aug 28, 2024 8:26 am
Forum: Nagios XI
Topic: Possible to create an alert in Nagios XI for when a server is turned "on"?
Replies: 3
Views: 1336

Re: Possible to create an alert in Nagios XI for when a server is turned "on"?

Seconded for the negate function. I used the negate function in Nagios and had it set so if a ping went through successfully, it would generate a single alert email.
by tsample
Wed Aug 28, 2024 7:50 am
Forum: Nagios XI
Topic: MSSQL Monitoring Issue
Replies: 5
Views: 5428

MSSQL Monitoring Issue

NagiosXI version: 2024R1.2 OS: CentOS9 Issue: MSSQL monitoring throws the following error when trying to connect to any SQL database/server on the network: ERROR: [run_check] CRITICAL: Could not connect to odbc:Driver=FreeTDS:Server=xx.xx.xx.xx:Port=1433:dbname=master:charset=UTF8 as sa (Exception:...