Share via

How to Deploy an Operations Manager 2007 Data Warehouse Using the Command Line

  • Article

Applies To: Operations Manager 2007 R2

You can use the following command-line example to deploy Operations Manager 2007 Data Warehouse. The account used to run Reporting2007.msi must have administrative privileges on the targeted computer.

Important

Before you perform this procedure, be sure that the account you plan to use for the Data Warehouse Write account and the Operations Manager action account has SQL Login rights and is an administrator on the Operations Manager database. Otherwise, setup fails and all changes are rolled back, which might leave SQL Reporting Services in an inoperable state.

If SRS Server, SQL Server, or Report Server are installed using the default instance, you need to specify only the computer name.

To deploy Operations Manager 2007 Data Warehouse using the command line

  1. Open the command window.

  2. At the prompt, for example, type the following:

    %WinDir%\System32\msiexec.exe /i \\path\Directory\Reporting2007.msi /qn /l*v "%Temp%\LOGS\REPORTING_INSTALL.LOG" ADDLOCAL="MOMREPORTINGDB" SQLSVR_INSTANCE="%COMPUTERNAME%\INSTANCE1" MOMREPORTINGDBNAME=<DB Name> DB_SIZE=”1000”

    Warning

    The installation of System Center Operations Manager 2007 Reporting will integrate the security of the chosen SQL Reporting Services Server Instance with role-based security. Any reports previously installed on this instance may become inaccessible.

  3. When the install completes, close the command window.

The following is a list of the command-line properties that are available for Reporting2007.msi.

  • ADDLOCAL - Specifying "MOMREPORTINGDB" causes the command to install the Reporting Data Warehouse component.

  • SQLSVR_INSTANCE - The SQL Server database instance. You must use the format of computername\instance when specifying instances of the SQL Server Database. Do not specify an instance with an alias. If the instance name is not the same case as the one used by SQL Reporting Services, the command-line Reporting Server setup fails.

  • MOMREPORTINGDBNAME - Specifies the name for the Reporting Data Warehouse. The default is "OperationsManagerDW".

  • DB_SIZE - Configures how much space (measured in MB) to allocate for the Reporting Data Warehouse database as defined with the ADDLOCAL parameter.

See Also

Tasks

How to Deploy the Reporting Server Using the Setup Wizard in Operations Manager 2007
How to Deploy an Operations Manager 2007 Reporting Server Using the Command Line

Other Resources

How to Deploy Reporting in Operations Manager 2007