Before upgrading your SQLcompliance Agents, review the permissions requirements and how the SQLcompliance Agent works.
If you manually installed the SQLcompliance Agent on the audited SQL Server computer, use the setup program to upgrade the agent locally. |
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:
You can use the SQL Compliance Manager setup program to upgrade the SQLcompliance Agent on the local computer that is running the registered SQL Server instance. Use this approach when you are upgrading the SQLcompliance Agent on a registered SQL Server where you manually installed the agent.
You can easily upgrade a SQLcompliance Agent for a SQL Server instance located in a Windows cluster by running the setup program. Perform the following steps on each node (computer) of the cluster.
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:
SETUP.EXE
in the root of the installation kit.
Idera Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|