NC_NET / Windows 2003 / MSSQLSERVER - not recognized

[Mark.Law at thomson.com]

>From the command line "net start" returns "SQL Server (MSSQLSERVER)" without the quotes for the SQL service.

I wrote a short script that does the service check below with this result (it only seems that the SQL stuff is failing)

Testing: SQL Server (MSSQLSERVER)
SQL Server (MSSQLSERVER): Unknown

Testing: SQL Server Agent (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER): Unknown

Testing: SQL Server Broswer
SQL Server Broswer: Unknown

Testing: SQL Server FullText Search (MSSQLSERVER)
SQL Server FullText Search (MSSQLSERVER): Unknown

Testing: SQL Server Integration Services
SQL Server Integration Services: Unknown

Testing: System Event Notification
System Event Notification: Started

Testing: Automatic Updates
Automatic Updates: Started


-----Original Message-----
From: Davy Gaussen [mailto:nagiosadmin at snef.fr] 
Sent: Tuesday, April 25, 2006 10:40 AM
To: Law, Mark (TSH Center); nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] NC_NET / Windows 2003 / MSSQLSERVER - not recognized

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 : nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] De la part de
Mark.Law at thomson.com
Envoyé : mardi 25 avril 2006 16:18
À : nagios-users at 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=k&kid0709&bid&3057&dat1642
_______________________________________________
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






-------------------------------------------------------
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&kid0709&bid&3057&dat1642
_______________________________________________
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