Page History
Before upgrading your SQLcompliance SQL Compliance Agents, review the permissions requirements and how the SQLcompliance SQL Compliance Manager Agent works.
Info |
---|
If you manually installed the SQLcompliance Agent on the audited SQL Server computer, use the setup program to upgrade the agent locally. |
Consider the scenarios described below for SQL Compliance Manager Agent installation and upgrade.
If the SQL Compliance Manager Agent was:
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.
Note |
---|
To upgrade the agent manually with the command line, it is required to use only the SQL Compliance Manager Agent MSI. |
Anchor | ||||
---|---|---|---|---|
|
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.
Info |
---|
If you deployed an agent on a remote server via the SQL Compliance Manager console and want to upgrade it to this build, you can also use the upgrade command of the SQL Compliance Manager silent installer. |
Anchor | ||||
---|---|---|---|---|
|
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.
Anchor | ||||
---|---|---|---|---|
|
To upgrade the IDERA SQL Compliance Manager Agent for versions 5.5 and later use the following command:
Code Block |
---|
msiexec /i "<Path_to_Agent_MSI>\SQLcomplianceAgent-x64.msi" /l*v InstallAgent.log COLLECT_SERVER="IderaCollectionServerName" INSTANCE="AgentSQLServerInstanceName" TRACE_DIRECTORY="C:\Program Files\Idera\SQLcompliance\AgentTraceFiles" SERVICEUSERNAME="Domain\Username" PASSWORD="!mySec@tP@55w0rD" STARTSERVICE="TRUE" SILENT="1" REINSTALLMODE=vamus REINSTALL=All AllUsers=1 /qb+ |
Upgrade an agent in a clustered environment
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.
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
SETUPSQLCMInstall.EXE
in the root of the installation kit. - Click INSTALL on the Setup tab of the setup program.
- 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 On the Install window, click Cluster Configuration Console.
- Once the setup wizard launches, click the Next to complete the upgrade.
- 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.
- 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 Bring the SQLcompliance Agent generic service online.
Scroll pdf ignore |
---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |