Checking an MSSQL

[Tom DE BLENDE]

Try the check_mssql.sh script in the contrib:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/nagiosplug/nagiosplug/contrib/

Ian Farr wrote:
> Hello all,
>  
> I would like to check an MS SQL 2000 database, and was wanting to know 
> if there are any people out there doing this already.
>  
> I know I can check the NT service with NSClient, but I wanted to do 
> something a little more than that to make sure that the SQL service is 
> indeed accepting requests and processing them.
>  
> My idea was to have an ODBC connection from the nagios box to the MS SQL 
> box and process the following:
>  
> 1 - read data from a table
> 2- write new data to a table
> 3 - read the new data from a table to make sure that it worked
> 4 - delete data from the table
> 5 - read the table again to make sure that the data is gone.
>  
> any ideas if something like this exists before I go down the road of 
> trying to create my own script with unix ODBC and all that???
>  
> Thanks for the help..
> ____________________
> Ian Farr
> Director of Network Infrastructure
> Oceanwide.com
> 514-289-9090 ext 234
>  




-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com

_______________________________________________
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