How to use modern MS SQL driver?

Q: Which driver should I use to monitor MS SQL servers?

A: MS SQL database monitor runs SQL queries against Microsoft SQL Server. To do that, IPHost Network Monitor can use one of the following drivers:

  • SQLOLEDB (deprecated) – Microsoft OLE DB Provider for SQL Server,
    or
  • MSOLEDBSQL – Microsoft OLE DB Driver for SQL Server

The former is MS Windows built-in driver, it can be used by IPHost Network Monitor right away. However, this driver has been marked as deprecated by Microsoft.

Microsoft currently recommends to use MSOLEDBSQL; however, that driver should be explicitly downloaded and installed by user.

To choose which driver to use, change “Driver” drop-down in MS SQL database monitor parameters accordingly:

Choose MS SQL driver

If IPHost is installed on older MS Windows version (without latest updates applied), or if you have to monitor older versions of MS SQL Server, the newer driver (MSOLEDBSQL) may not work for you. In such a case, use SQLOLEDB (deprecated) driver.

To monitor modern MS SQL Server versions, especially if you need TLS v1.1/v1.2 support, use MSOLEDBSQL.

If monitor reports “Cannot open database: Class not registered” when polled, it means the MSOLEDBSQL driver has not yet been installed, and you are required to download it from
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server
and install.

Note: you can choose driver versions, starting from IPHost v5.2. Earlier IPHost versions are always using SQLOLEDB (deprecated) driver.

Please contact technical support in case you still have problems configuring the MS SQL database monitor.

Related topic