[Nagiosplug-help] Recommendations on checking a MS SQL Server?

[Thomas Guyot-Sionnest]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 28/09/07 09:51 AM, Zembower, Kevin wrote:
> I'm looking for recommendations for checking a Microsoft SQL server
> running on a Windows Server 2003 host. Searching NagiosExchange turned
> up 'check mssql databases status by snmp' and 'check_mssql_sproc'. I'm
> currently blocked by a firewall from passing SNMP messages, so the first
> one's out. The second one seems to require writing a stored procedure on
> the SQL Server and executing it, something I've never done and that
> looks to be involved and time-consuming.
> 
> Searching Google turned up references to check_mssql.sh. When I was able
> to track it down, it seems to require a program 'tsql' which I think is
> a Windows program that executes a SQL script.
> 
> I'd like to ask this group's advice on how to most easily test the
> operation of a SQL server remotely, if I can't use SNMP. I'm not adverse
> to executing an HTML query to this database and checking the answer,
> since the SQL database runs a search web page.

tsql is a program that comes with FreeTDS, which is an OSS software that
runs on Linux & others.

I don't have much time to write the details right now; look at this
program I written recently. In the header of the file you'll see all the
required software (Don't forget to compile FreeTDS with the right
options; read carefully the header of this script)

If you need any more help I'll be glad to help. Nb: this script can
check other db types depending on the way it's called (i.e. using symlinks).

Thomas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG/RHA6dZ+Kt5BchYRAihFAKDzAafdLBuZxdW/G2nYLcr2zWXeOQCg7ObM
k9oXlXv2ZpgOZEAA20TH4P4=
=E9wp
-----END PGP SIGNATURE-----
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: check_mssql
URL: <https://www.monitoring-plugins.org/archive/help/attachments/20070928/c6cca6bc/attachment.ksh>