You can use the following command-line example to deploy, on the same computer, the Operations Manager 2007 Reporting Server and Reporting 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 Reporting on a single computer using the command line

  1. Open the command window.

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

    %WinDir%\System32\msiexec.exe /i %temp%\Reporting\i386\Reporting2007.msi /qn /l*v %Temp%\OM_Reporting_Install.log DBWRITEACTIONSUSER=<user> DBWRITEACTIONSDOMAIN=<domain> DBWRITEACTIONSPASSWORD=<password> SRS_SERVER=<computer>\Instance1 MGSERVER=<computer> SQLSVR_INSTANCE=<computer>\Instance1 DATAREADER_USER=<user> DATAREADER_DOMAIN=<domain> DATAREADER_PASSWORD=<password> REPORT_SERVER_FULL_HTTP_PATH=”http://<computer>:80/ReportServer$INSTANCE1”.

    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.

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

    • DBWRITEACTIONSUSER - User name for the Data Warehouse Write account.

    • DBWRITEACTIONSDOMAIN - Domain name for the Data Warehouse Write account.

    • DBWRITEACTIONSPASSWORD - Password for the Data Warehouse Write account.

    • SRS_SERVER - The SQL Server reporting services instance.

    • MGSERVER - The computer name for the Root Management Server.

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

    • DATAREADER_USER - User name for the data reader account.

    • DATAREADER_DOMAIN - Domain name for the data reader account.

    • DATAREADER_PASSWORD - Password for the data reader account.

    • REPORT_SERVER_FULL_HTTP_PATH - Path to the report server instance.

See Also

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