Perform a silent installation of the SQLCM Agent

Use the following commands to perform a silent installation or upgrade the IDERA SQL Compliance Manager Agent.

For a fresh installation (Default Installation Path):

msiexec /i "SQLcomplianceAgent-x64.msi" /l*v InstallAgent.log 
COLLECT_SERVER="IderaCollectionServerName" 
INSTANCE="AgentSQLServerInstanceName" 
SERVICEUSERNAME="Domain\Username" 
PASSWORD="!mySec@tP@55w0rD" 
STARTSERVICE="TRUE" 
SILENT="1" 
AllUsers=1 /qb+

Upgrade:

msiexec /i "SQLcomplianceAgent-x64.msi" /l*v InstallAgent.log 
SERVICEUSERNAME="Domain\Username" 
PASSWORD="!mySec@tP@55w0rD" 
STARTSERVICE="TRUE" 
SILENT="1" 
REINSTALLMODE=vamus 
REINSTALL=All  
AllUsers=1 /qb+

Note

You can locate the MSI file within the SQLCM installation directory. Simply check the directory where either the SQL Compliance Manager Management Console or the SQL Compliance Manager Collection Service has been installed.

Use and add the associated parameters according to your needs for your installation/upgrade from the chart below.

Associated parameters include:

Parameter	Description
COLLECT_SERVER	The machine where the Collection server is installed and where you want to collect audited data.
INSTANCE	The SQL Server instance name where you want to install the Agent.
INSTALLDIR	(Optional) Specify the target installation directory.
TRACE_DIRECTORY	(Optional) The Agent trace file directory where you want to generate the trace files on the Agent server. If the parameter is not specified, the agent trace file directory will automatically be located in the installation directory.
SERVICEUSERNAME	The Windows service account used to run the Agent service. This account must be local admin and have sa rights to the monitored SQL Server.
PASSWORD	The password for the service account.
REINSTALL	All, instructs the installer to reinstall all pre-installed features.
REINSTALL MODE	Vamus, indicates the type of reinstall to perform.
STARTSERVICE	Denotes whether to start the service.
SILENT	Indicates to the installer that it is installed silently.
ALLUsers	1, perform a "per-machine" installation. Omit this parameter to perform a "per-user" installation.

The login and password must be encrypted strings. On IDERA SQL Compliance Manager 3.0 and later, you can encrypt the login and password using the encrypt command on the command line to get an encrypted version of the string that can then be used:

sqlcmcmd encrypt THESTRING

Note

Should the password contain the ¨^¨ special character, please consider enclosing the password string in between quotation marks, as shown below.

sqlcmcmd encrypt "THESTRING"

Also, note that this option would work if the password string does not contain double-quotes.

Content

Space Tools

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal