How to Deploy a Data Warehouse Management Server Using the Command Line
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
Use the following procedures to deploy a Service Manager data warehouse and databases, including the Operations Manager and Configuration Manager data mart databases, in System Center 2012 – Service Manager.
Use the following procedures to deploy the data warehouse with the Operations Manager and Configuration Manager data mart databases. If you want to install the data warehouse management server and data warehouse databases on the same computer, use the same computer name that you are running Setup on for all instances of [computer name]. If you want to deploy the databases on a separate computer, adjust the [computer name] entries accordingly.
The /AnalysisServerDatabaseDataFilePath is optional, and if it is not used, the default path will be used.
The DWStagingAndConfig database and the DWRepository database must reside on the same instance. Make sure that you specify the same computer and instance for the /StgConfigSqlServerInstance and /RepositorySqlServerInstance command-line options.
Log on to the computer where you want to install the Service Manager console using administrative credentials.
Open a command window.
You must run the command prompt with administrative credentials.
At the command prompt, change directories to the location of the Service Manager installation media, and then type the following:
Start /Wait Setup.exe /Install:Datawarehouse /AcceptEula:[YES/NO] /RegisteredOwner:[owner name] /RegisteredOrganization:[company name] /ProductKey:[25-character product key] /CreateNewDatabase /AdminRoleGroup:[domain\account name] /StgConfigSqlServerInstance:[computer name] /RepositorySqlServerInstance:[computer name] /DataMartSqlServerInstance:[computer name] /ReportingServer:[computer name] /ReportingWebServiceURL:"http://[computer name]:80/ReportServer" /ServiceRunUnderAccount:[domain\account name\password] /DatasourceAccount:[domain\account name\password] /CustomerExperienceImprovementProgram:[YES/NO] /EnableErrorReporting:[YES/NO] /ManagementGroupName:DW_improvement /OMDataMartSqlServerInstance:[computer name] /CMDataMartSqlServerInstance:[computer name] /AnalysisServerInstance:[computer name] /AnalysisServerDatabaseDataFilePath:[path to analysis database] /ASRunUnderAccount:[domain\account name\password] /Silent