NC_NET / Windows 2003 / MSSQLSERVER - not recognized

[Thibault Genessay]

Mark.Law at thomson.com 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=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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