[Nagios-users] NC_NET / Windows 2003 / MSSQLSERVER - not recognized

2006-04-25 Thread Mark.Law

Has anyone run into a problem with NC_NET not being able to see running
SQL processes on Windows 2003 machines?

The net start command shows the server running as 
SQL Server (MSSQLSERVER), but this test always fails under NC_NET.

Any help appreciated.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid0709bid3057dat1642
___
Nagios-users mailing list
Nagios-users@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


Re: [Nagios-users] NC_NET / Windows 2003 / MSSQLSERVER - not recognized

2006-04-25 Thread Thibault Genessay

[EMAIL PROTECTED] wrote:

Has anyone run into a problem with NC_NET not being able to see running
SQL processes on Windows 2003 machines?

The net start command shows the server running as 
SQL Server (MSSQLSERVER), but this test always fails under NC_NET.


Any help appreciated.
  
I don't know  how NC_NET performs its checks, but if it is through WMI 
then you might fall into the same problem that we have. In a nutshell, 
the SQL Server 2000 WMI provider is buggy and the counters may stop 
responding. You can figure this out by checking in the perfmon; the 
counters might be there but invisible to WMI consumers (aka soft bug) or 
totally missing (hard bug). In both cases, only a server reboot can 
solve the problem.
It might be worth having a look at CleWMI - great command line tool to 
query WMI - to check whether the counters are present.


--
Thibault



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Nagios-users mailing list
Nagios-users@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


RE: [Nagios-users] NC_NET / Windows 2003 / MSSQLSERVER - not recognized

2006-04-25 Thread Davy Gaussen
Are you sure that the ServiceName is MSSQLSERVER only ? Usually, these kind
of services have MSSQLSERVER$$YOURBASENAME type of name. 

Go to : services.msc, then edit properties on your service and check out the
ServiceName parameter.

And do you want to test the process or the service SQL in your server ?

If you want to check service, you have to do in your nagios monitoring hosts
:
# /yourpathto_check_nt/check_nt -H HOSTADDRESS -p 1248 -v SERVICESTATE -l
MSSQLSERVER -s None -t 30

If you want the process :
#/yourpathto_check_nt/check_nt -H HOSTADDRESS -p 1248 -v PROCSTATE -l
sqlservr.exe -s None -t 30

Good luck !

Davy Gaussen


-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] De la part de
[EMAIL PROTECTED]
Envoyé : mardi 25 avril 2006 16:18
À : nagios-users@lists.sourceforge.net
Objet : [Nagios-users] NC_NET / Windows 2003 / MSSQLSERVER - not recognized


Has anyone run into a problem with NC_NET not being able to see running
SQL processes on Windows 2003 machines?

The net start command shows the server running as 
SQL Server (MSSQLSERVER), but this test always fails under NC_NET.

Any help appreciated.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=kkid0709bid3057dat1642
___
Nagios-users mailing list
Nagios-users@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




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid0709bid3057dat1642
___
Nagios-users mailing list
Nagios-users@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