Database Check

General information

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.

MS SQL Server specific

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.

Status Conditions

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 be true.

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.

Check Settings

Besides the standard properties, you should specify the following ones for this check:

• Database Engine - Either ODBC or MS SQL Server.
• Database - Specify a database in the selected database engine. It can be an ODBC DSN name or a MS SQL server- specific SQL-DMO connection string.
• Authentication - If the MS SQL server database engine is selected you can authenticate both using Windows authentication and specifying username/password directly. If you select the ODBC database engine, you have to specify username/password and cannot use Windows authentication.
• SQL Query - Specify an SQL query that should be executed during the checking process.
• Fail if the first record in the first column is - Assuming that the first cell of the first record in the result set is an integer, you can specify a criterion for comparison. The check will be failed if this criterion will not coincide with that in the result set
• Fail if the record set contains no records - If your query returns an empty record set, the check will be failed.