Page History
Before upgrading your SQL Compliance Agents, review the the permissions requirements and and how the SQL Compliance Manager Agent works.
Consider the scenarios described below for SQL Compliance Manager Agent installation and upgrade.
If the SQL Compliance Manager Agent wasis:
installed and deployed 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 the main installer, it has to be upgraded using the main installer.
installed and deployed manually using the the install command line, it has to be upgraded using the 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 | ||||
---|---|---|---|---|
|
...
To upgrade a remote SQLcompliance Agent:
- In the Navigation pane, click click Administration, and then select select Registered SQL Servers in in the Administration tree.
- In the view pane, right-click the SQL Server instance for which you want to upgrade the SQLcompliance Agent.
- Select Select Upgrade Agent from 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 | ||||
---|---|---|---|---|
|
...
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+ |
To upgrade the IDERA SQL Compliance Manager Agent from 4.5 to this version and later, use the following command:
Code Block |
---|
msiexec /i "\SQLcomplianceAgent-x64.msi" /l*v InstallAgent.log SERVICEUSERNAME="Domain\Username" PASSWORD="!mySec@tP@55w0rD" STARTSERVICE="TRUE" SILENT="1" AllUsers=1 /qb+ |
Upgrade an agent in a clustered environment
...
- 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 Run
SQLCMInstall.EXE
in in the root of the installation kit. - After completing the 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 Click Yes if 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 the Cluster Configuration Console automatically 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 select Properties.
- Go to the the Registry Replication tab tab, set the Root Registry Key to
Software\Idera\SQLCM
, save the changes and close the the Properties window window. - Right-click the SQL Compliance Manager Agent service and bring the generic service online.
Scroll pdf ignore |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...