Nagios Monitoring Microsoft SQL Express 2005

[Seth Simmons]

Keep in mind you will still have an issue if you keep the $

In the template you would use:

check_nt_service!MSSQL$"$"MICROSOFTSSEE

I had to make that change in my template else the check will fail as MSSQL$MICROSOFTSSEE


-----Original Message-----
From: Martinez, Eduardo [BSD] - ADM [mailto:emartine at bsd.uchicago.edu] 
Sent: Tuesday, November 25, 2008 3:45 PM
To: Mattias Ryrlén
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Nagios Monitoring Microsoft SQL Express 2005

I will give this a shot and let you know how it goes.

-Eduardo

-----Original Message-----
From: Mattias Ryrlén [mailto:mattias.ryrlen at op5.com] 
Sent: Tuesday, November 25, 2008 1:51 PM
To: Martinez, Eduardo [BSD] - ADM
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Nagios Monitoring Microsoft SQL Express 2005

Hi Eduardo,

Martinez, Eduardo [BSD] - ADM skrev:
>  
> 
> Any assistance would be appreciated. I am having issues monitoring this 
> service in Nagios via nsclient  on a windows 2003 server.
> 
>  
> 
> On the commandline this works great:
> 
>  
> 
> check_nt -H adm-patches -p 1248 -v SERVICESTATE -l 'MSSQL$MICROSOFT##SSEE'
> 
>  
> 
> It report that all services and up and running. However, in the template:
> 
>  
> 
>  
> 
> define service{
> 
>         use                             template
> 
>         host_name                       hostname
> 
>         check_command                   
> check_nt_service!'MSSQL$MICROSOFT##SSEE'
> 
>         service_description            Microsoft SQL Express 2005
> 
> }
> 
>  
> 
>  
> 
> This reports WARNING 11-25-2008 13:04:30 0d 0h 1m 1s 1/5 
> MSSQL$MICROSOFT##SSEE$: Unknown 
> 
> I've been searching through forums but haven't found this. I'm sure 
> someone has run into this issue.
What version of NSclient++ do you have, i found a bug in NSClient++ that 
it can't handle # correct in servicenames.

You can rename a service if you want to remove the # Chars.

Regedit -> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
rename the folder named MSSQL$MICROSOFT#SSEE to eg MSSQL$MICROSOFT_SSEE

reboot the _windows_ machine and your service is now named 
MSSQL$MICROSOFT_SSEE

> 
>  
> 
> Any help would be appreciated.
> 
>  
> 
> Thanks,
> 
> -Eddie
> 
>  
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null


-- 
Vänliga hälsningar / Best Regards
Mattias Ryrlén

__________________________
op5 AB
Första Långgatan 19
SE-413 27 Göteborg
Mobil: +46 735-17 70 99
Support: +46 31-774 09 24
www.op5.com


This email is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If the reader of this email message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this email in error, please notify the sender and destroy/delete all copies of the transmittal. Thank you.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null