KBI 310602 Could not call methods of dispatch interface for XTSQLMonitor.basic’. Error: SQL-DMO is not installed

Version

Argent SQL Server Monitor (XT) — all versions

Date

Wed, 10 July 2013

Summary

When executing a Rule in Argent SQL Server Monitor (XT) from a Remote Monitoring Engine, the following message is displayed in the logs:

“Could not call methods of dispatch interface for ‘XTSQLMonitor.basic’. Error: SQL-DMO is not installed”

This KBI explains the steps to be performed to Install SQL Server Distributed Management Objects (SQL-DMO).

Technical Background

Argent’s SQL monitoring Rules require SQL-DMO, which is essentially a Microsoft library of functions for monitoring SQL Server databases.

On Microsoft SQL Server 2008 and above, SQL-DMO is not installed by default.

In order to obtain the SQL-DMO libraries, the “SQL Server 2005 Backward Compatibility Components” need to be installed on any Argent engine that performs the monitoring


Note: Installing the SQL Server 2005 Backward Compatibility Components on a SQL production machine (regardless of version) does not affect the operation of the SQL Server — it simply installs libraries that are missing from SQL Server 2008 and above

Microsoft has released no knowledge-base articles suggesting there are any issues with the SQL Server 2005 Backward Compatibility Components when used in conjunction with later versions of SQL Server

Resolution

On the Argent Monitoring engine that is performing the monitoring:

  1. Download Microsoft SQL Server 2005 Backward Compatibility Components from Microsoft. Next, execute the setup file.
  2. On Welcome to the Install Wizard for Microsoft SQL Server 2005 Backward Compatibility Setup, click Next.
  3. On License Agreement, select ‘I accept the terms in the license agreement‘. Then, click Next.
  4. On Registration Information, enter your personal information. Then, click Next.
  5. On Feature Selection, ensure that SQL Distributed Management Objects is selected. Then, click Next.
  6. On Ready to Install the Program, click Install.
  7. On Completing the Microsoft SQL Server 2005 Backward Compatibility Setup, click Finish.
  8. From C:\Program Files\Microsoft SQL Server \80\Tools\Binn directory, execute: REGSVR32 SQLDMO.DLL to register the SQL-DMO components.

Configure the Monitoring Group to use the correct Argent Monitoring Engine:

Test the Relator with the option “Run the Test using Node Associated Monitoring Engine” checked.

The Relator should now pass, and the error message previously seen should not appear: