Page History
...
You can upgrade the SQLcompliance Agent remotely using the Management Console. Use this approach to upgrade agents on any registered SQL Server where you remotely installed the agent.
To upgrade a remote SQLcompliance Agent:
- In the Navigation pane, click Administration, and then select Registered SQL Servers in the Administration tree.
- In the view pane, right-click the SQL Server instance for which you want to upgrade the SQLcompliance Agent.
- Select Upgrade Agent from the context menu.
...
| Note |
|---|
When you upgrade the SQLcompliance Agent, the associated CLI trigger is deleted and recreated. This update can take several minutes. During this time, the SQLcompliance Agent status will show that it is unavailable due to a CLR error. Use the Activity Log to track when the new CLI trigger install completes. |
To upgrade an agent on a cluster node:
- 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
SETUP.EXEin the root of the installation kit. - Click INSTALL on the Setup tab of the setup program.
- On the Install window, click Cluster Configuration Console.
- On the IDERA SQL Compliance Manager Cluster Configuration dialog, click Yes to start the upgrade process, and then click Next to continue. 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.
- Bring the SQLcompliance Agent generic service online.
...