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
Open the command window.
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.
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
- DB_SIZE - Configures how much space (measured
in MB) to allocate for the Reporting Data Warehouse database as
defined with the ADDLOCAL parameter.
Did you find this information useful? Please send your suggestions and comments about the documentation.