Page History
...
If the SQL Compliance Manager Agent wasis:
installed and deployed via SQL Compliance Manager console, it has to be upgraded using the application console. Alternatively, it can be upgraded via command line.
installed and deployed with the main installer, it has to be upgraded using the main installer.
installed and deployed manually using the install command line, it has to be upgraded using the upgrade command line.
...
- Log on with an administrator account to the cluster node. Start with the currently active node.
- Bring the SQLcompliance Agent generic service for this SQL Server resource group offline.
- Run
SQLCMInstall.EXE
in the root of the installation kit. - After completing the upgrade on a clustered environment, go to the SQL Compliance Manager install path. Unless you have specified a different path, the one by default is
C:\Program Files\IDERA\SQLCompliance.
Run
SQLcomplianceClusterSetup.EXE.
- The installer displays a confirmation message. Click Yes if you want to upgrade the IDERA Cluster Configuration Console.
- Once the setup wizard launches, click the Next to complete the upgrade.
- After the upgrade completes, the Cluster Configuration Console automatically starts.
- When prompted, specify the directory location you want SQL compliance manager to use to store CLR trigger assemblies.
- In Windows Services, stop the SQL Compliance Manager Agent service and set the Startup type to Manual.
- Open Microsoft Failover Manager, right-click the SQL Compliance Manager Agent service, and select Properties.
- Go to the Registry Replication tab, set the Root Registry Key to
Software\Idera\SQLCM
, save the changes and close the Properties window. - Right-click the SQL Compliance Manager Agent service and bring the generic service online.
...