Export (0) Print
Expand All

How to Deploy a Data Warehouse Management Server Using the Command Line

Updated: November 1, 2013

Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - 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.

Deploying the Data Warehouse

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.

To deploy the data warehouse management server, data warehouse databases, and optional data marts

  1. Log on to the computer where you want to install the Service Manager console using administrative credentials.

  2. Open a command window.

    You must run the command prompt with administrative credentials.

  3. 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

See Also

For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft