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.

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”

    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

Did you find this information useful? Please send your suggestions and comments about the documentation.