IDERA SQL Compliance Manager 5.4 depends on certain Microsoft components that did not ship with SQL Server versions prior to SQL Server 2012 SP1. If you are installing SQL Compliance Manager’s collection service on a repository running on SQL Server 2012 or below, it is necessary to install these components manually.
For your convenience, these components are included in the SQL Compliance Manager 5.4 download. You may also download them from the Microsoft download page for the SQL Server 2016 Feature Pack (select SharedManagementObjects.msi and SQLSysClrTypes.msi for 32-bit or 64-bit, depending on which version you are installing). The SQL Server 2016 Feature Pack is backward compatible with prior versions of SQL Server and can coexist with SQL Server 2012 and below.
Installation or upgrade instructions
SQL Compliance Manager Windows Desktop Client or Collection Service
SQL Server 2012 SP1, SQL Server 2014, or SQL Server 2016
- Run IDERASQLCmInstallationKit to upgrade or install IDERA SQL Compliance Manager 5.4.
SQL Server 2012 or below
Install the following three packages in order:
Run SQLSysClrTypes.msi to install the System CLR Types assembly.
Run SharedManagementObjects.msi to install the Shared Management Objects assembly.
Run IDERASQLCmInstallationKit to upgrade or install SQL Compliance Manager 5.4.
SQL Compliance Manager Agent
You may deploy the SQL Compliance Manager agents from the SQL Compliance Manager desktop client.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal