Platform Deployment Guide › Technical Information › Command Line Parameters for Msiexec.exe › Database Variables › Examples

Examples

Example 1

This example installs a CMS and specifies a SQL Server database engine. The host server is MyDBServer, which uses IP port 1480; the database account is fred (password: xfz3105labp); the \Data folder is located on Server02 at \CA DataMinder\CA DataMinder_data.

msiexec /i <Path>\server.msi 
  // 
  // General variables go here
  // 
  WGNDATABASETYPE=MSSQL
  WGNDATABASESERVER=MyDBServer
  WGNDATABASEIPPORT=1480
  WGNDATABASENAME=My_CA DataMinder_Database
  WGNDATABASEUSERNAME=fred
  WGNDATABASEPASSWORD=xfz3105labp
  WGNDATA=\\Server02\CA DataMinder\CA DataMinder_data

Example 2

This example upgrades a SQL Server database engine. The command create a Reporting User and an Unrestricted Search User. It also enables the data warehouse and turns on collection of event participant data.

msiexec /i %camden_msi_path% /qb 
  // 
  // General variables and 
  // database variables go here
  // 
  WGNDBREPORTINGUSERNAME=wgnreporting 
  WGNDBREPORTINGPASSWORD=%PASSWORD% 
  WGNDBREPORTINGCREATEACCOUNT=1 
  WGNDBUNRESTRICTEDUSERNAME=wgnrestricted 
  WGNDBUNRESTRICTEDPASSWORD=udz8343lgs 
  WGNDBUNRESTRICTEDCREATEACCOUNT=1 
  WGNDWENABLE=1 
  WGNDWEVENTPARTICIPANTS=1 
  WGNDBADMINUSERNAME=sa 
  WGNDBADMINPASSWORD=hyd8734pcs