|Network Eagle Checks|
This check monitors a database. It supports database connections via ODBC and a direct connection to the MS SQL server. This check can either test only if it is possible to connect to the selected database (if you switch off check box Run SQL Query) or execute a custom SQL query and perform some basic checks in the result.
To check your MS SQL Server via a direct connection, you have to install SQL-DMO. SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft® SQL Server™ database and replication management. We support MS SQL Server 7.0 and MS SQL Server 2000. If you do not want to install MS SQL Client software, you can check MS SQL via ODBC.
Successful - The connection to the specified database has to be successfully established.
If you specify an SQL query, it has to be executed without errors. If you select the
"Fail if result set contains no records" checkbox, the result set returned by your SQL query
must contain at least one record. The condition defined for the first cell of the first record must
Failed - If the connection to the database cannot be established. If your SQL query cannot be executed or returns a result set that does not satisfy the conditions specified on the Settings page of this check.
Besides the standard properties, you should specify the following ones for this check: