Use the Operations Manager 2007 Setup Wizard to deploy the Reporting Server and Reporting data warehouse on a single computer.

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

If the Operations console is open during setup, the Reporting button does not display until you close and then reopen the console. Users must be members of the Operations Manager Report Operators or Operations Manager Report Security Administrators user role to be able to run reports. For more information about Operations Manager 2007, see http://go.microsoft.com/fwlink/?LinkId=85414.

To deploy an Operations Manager   2007 Reporting using the Setup Wizard

  1. Log on to the computer with an account that is a local administrator and has system administrator privileges on the Reporting data warehouse, system administrator privileges on the Operations Manager database, and membership in the Operations Manager administrator user role.

  2. On the Operations Manager 2007 installation media, double-click the SetupOM.exe file.

  3. On the Start page, click Install Operations Manager 2007 R2 Reporting.

  4. When the Welcome to Operations Manager 2007 R2 Reporting Setup page displays, click Next.

  5. On the End-User License Agreement page, read the license agreement, and if you want to continue, click I accept the terms in the license agreement, and then click Next.

  6. On the Product Registration page, type the information in the text boxes (the CD key is required), and then click Next.

  7. On the Custom Setup page, leave the components set to their defaults, and then click Next.

  8. On the Connect to the Root Management Server page, in the Root Management Server text box, type the computer name of the root management server and then click Next.

    Note
    Do not click Browse to choose an installation folder. When you install Reporting and Operations Manager 2007 on the same computer, Reporting must be installed in the same folder as Operations Manager 2007. The Setup Wizard automatically installs both programs in the same folder.
  9. On the SQL Server Database Instance page, click SQL Server database instance, click or type the name of the database instance that will host the database (for example, computername\INSTANCE1), and then click Next.

    Note
    You must use the format of computername\instance when specifying instances of the SQL Server Database. Do not use an alias to specify an instance.
  10. On the Database and Log File Options page, do the following:

    1. In the Database Name text box, type the name of the Reporting data warehouse or leave the default of OperationsManagerDW.

    2. In the Database size text box, type the initial size of the Operations Manager Reporting data warehouse or leave the default of 1,000 MB.

      Note
      To change the Data file location or the Log file location, click Advanced, make the changes, click OK, and then click Next.
    3. Click Next.

  11. On the SQL Server Reporting Services Instance page, click Enter the SQL Server Reporting Services Manager, select the instance of SQL Server on which you want to install the Operations Manager 2007 Reporting Services Server (for example, computername\INSTANCE1), and then click Next.

  12. On the Data Warehouse Write Account page, do the following:

    1. In the User Account text box, type the user account.

    2. In the Password text box, type the password.

    3. In the Domain list, select the domain or local computer from the list.

    4. Click Next.

      Note
      Do not try to enter a user account in Domain\User format. User Principal Name (User@Domain) is supported.
  13. On the Data Reader Account page do the following:

    1. In the User Account text box, type the user account.

    2. In the Password text box, type the password.

    3. In the Domain list, select the domain or local computer from the list.

    4. Click Next.

      Note
      Data Reader needs to be a local administrator on the computer for setup. After setup, you can remove that account from the local administrators group.
      Note
      Do not try to enter a user account in Domain\User format. User Principal Name (User@Domain) is supported.
  14. On the Operational Data Reports page, click Yes, send operational data reports to Microsoft to join CEIP, or click No, don't send operational data reports to Microsoft to decline participation, and then click Next.

  15. On the Ready to Install the Program page, click Install.

  16. On the Completing the Operations Manager Reporting Components Setup Wizard page, click Finish.

See Also


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