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.

 

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >