Network Monitor Product Home Page Built in checks Download

ActiveXperts Network Monitor MS SQL Server Monitoring

ActiveXperts Network Monitor is a software solution you need to scan your network servers, workstations and devices for failures or irregularities. With ActiveXperts Network Monitor, you can identify issues and fix unexpected problems before your others even know they've happened.
ActiveXperts Network Monitor maximizes network availability by monitoring all aspects of your servers, workstations, switches, routers, printers and any other devices. It can also detect temperature, humidity and other environmental aspects in your server rooms.

ActiveXperts Network Monitor uses OLE-DB and ADO to monitor the availability of databases. OLE-DB is an Application Programming Interface (API) for accessing different types of databases, incl. Microsoft SQL Server, Microsoft Access, Oracle and MySQL.

A Generic Database Query check requires the following parameters:

  • OLE DB (ADO) Connection String - The OLE DB connection string, for instance: DRIVER=Microsoft Access Driver(*.mdb);DBQ=\\SERVER03\Public\Northwind.mdb. You can use a password in this connections string. To hide the password, you can use the <%PASSWORD%> placeholder. When using this placeholder, ActiveXperts will automatically substitute this placeholder with the 'Password' field described below;
  • Password - This is the password string (shown as asterisks) that will substitute the <%PASSWORD%> field described above;
  • Database Query - The database query. The result of the check is determined by the result of this query;
  • Match Field - The field that will be matched to determine the result of the check;
  • Type - Type of field to be checked;
  • Field must be Equal To / Not Equal To / ... - Operator used to determine the result of the check;

Screenshot:

 (Click on image to enlarge)