In addition to the Setup Wizard, SQL Diagnostic Manager allows you to use the Microsoft installer in silent or quiet mode and to simplify SQL Diagnostic Manager deployment.
To run silent installation using Windows Authentication, type the following command-line in the Command Prompt window:
"path_to_exe_file" /v"/L*v C:\test.log
INSTANCE="SQLServerInstanceName"
REPOSITORY="SilentSLQdmDatabase"
SETUPTYPE="Typical"
SERVICEUSERNAME="domain\username"
SERVICEPASSWORD="password"
SQLSERVER_AUTHENTICATION="0"
SERVICE_SQLAUTHENTICATION="0" /quiet"
To run silent installation using SQL Authentication, type the following command-line in the Command Prompt window:
"path_to_exe_file" /v"/L*v C:\test.log
INSTANCE="SQLServerInstanceName"
REPOSITORY="SilentSLQdmDatabase"
SETUPTYPE="Typical"
SERVICEUSERNAME="domain\username"
SERVICEPASSWORD="password"
SQLSERVER_AUTHENTICATION="1"
SQLSERVER_USERNAME=”username”
SQLSERVER_PASSWORD=”password”
SERVICE_SQLAUTHENTICATION="0"
SERVICE_SQL_USERNAME=”SQLServerUserName”
SERVICE_SQL_PASSWORD=”SQLServerpassword” /quiet"
Select a setup type for your installation
You can choose which setup type to run by specifying Typical, Console, or Services in the SETUPTYPE field.
- The Typical setup type, the recommended option, installs the console, the SQL Diagnostic Manager services, and the repository.
- The Console setup type installs only the console.
- The Services setup type installs the SQL Diagnostic Manager services and the repository.