System Check reports "Microsoft SQL Server Management Objects Collection patch is not installed" during setup.

Products

• Workflow Solution
• ServiceDesk

Issue/Introduction

When trying to install Workflow Solution 7 or Service Desk 7 I receive the following error during the System Check portion of the setup:

Cause

There are three different files that must be installed on the Workflow Server if SQL is hosted remotely.  They also must be installed in a specific order due to dependencies.

Resolution

The following three files are necessary for a remote SQL 64bit host:

 

·         Microsoft SQL Server Native Client - sqlncli_x64.msi

·         SQL Server 2005 Management Objects Collection - SQLServer2005_XMO_x64.msi

·         Microsoft ADOMD.NET - SQLServer2005_ADOMD_x64.msi

 

They all need to be installed on the Workflow/ServiceDesk Server (not on the remote SQL Server) in the order listed above due to dependencies.  If some are already installed, they can be repaired in order instead of needing to uninstall and reinstall.

Applies To

Windows Server 2003 x64

SQL 2005 installed on a remote server