SQL service "Not Found" but running?

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
servoisgod
Posts: 1
Joined: Fri Aug 20, 2010 9:28 am

SQL service "Not Found" but running?

Post by servoisgod »

Hellos all!

I have a very frustraiting issue with one of my servers. I'm trying to monitor the SQL and SQL Agent running and for some reason, Nagios is saying that it can't find the service? The strange part is that I have this monitor setup one 4 other servers and it's working just fine for those? Below is how I have ALL other servers setup and this is working great for them.

define service{
use generic-service
hostgroup_name SERVERNAME
service_description SQL Server
check_command check_nt!SERVICESTATE!-d SHOWALL -l MSSQLSERVER
contact_groups GROUPNAME
}

I've double, triple and even stood on my head to see if I'm trying something wrong, but can't find any reason why this isn't working on the system? All other Nagios monitoring on this one server is working just fine, so I know that Nagios is setup and configured correctly on it. All servers are running the same version of Nagios also.

What would cause the exact same code to work on one server but not another?

Thanks!


Edit: I'm trying to get the formatting of the code to look like it does on the Nagios setup, but I can't get the spaces to show up correctly? :(
mmestnik
Posts: 972
Joined: Mon Feb 15, 2010 2:23 pm

Re: SQL service "Not Found" but running?

Post by mmestnik »

I don't follow. Please provide more information, versions and identify what's working. What did you mean by other 4 Servers?

Nagios Servers:
Verify installation of check_nt and compare versions.

Windows Servers:
Test check_nt with other options, try and monitor other metrics.


I've had the same issue with spaces, the solution was to use base64, here is an example:
http://go.nagios.com/forum/73/961
Locked