Page History
...
- 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.EXEin 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.
...