You can configure the Reporting data warehouse to combine reporting data from multiple management groups in Operations Manager 2007. For this procedure, it is assumed that a root management server, an Operations Manager database, a Reporting Server, and a Reporting data warehouse have been installed on Management Group 1. It is also assumed that a root management server and an Operations Manager database have been installed on Management Group 2. Use the following procedure to install Reporting on Management Group 2 by using the Reporting data warehouse on Management Group 1.

Note
Each management group requires its own instance of SQL Reporting Services.
Note
The System Center Data Access service on the computer in Management Group 2 must log on using a domain account. This feature does not work if the System Center Data Access service is logging on using the Local System account.

To add a second management group to Reporting

  1. Log on to the computer with an account that is a local administrator and has system administrator privileges on the Reporting data warehouse.

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

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

  4. On the Welcome to Operations Manager 2007 Reporting Setup page, click Next.

  5. On the End-User License Agreement page, 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, including the required CD key information, and then click Next.

  7. On the Custom Setup page, click Data Warehouse, click This component will not be available, and then click Next.

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

  9. On the Connect to the Operations Manager Data Warehouse page, do the following:

    Note
    The computer name and Reporting data warehouse name in this step refer to the computer located in Management Group 1.
    1. In the Enter the SQL Server database instance text box, click or type the name of the database instance that will host the database (for example, computername\INSTANCE1).

    2. In the SQL database name text box, type the name of the database.

    3. In the SQL Server Port text box, type the port number. The default is 1433.

    4. Click Next.

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

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

    Note
    The account you select must be a domain account that has rights on the computer in MG1.
    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, and then click Next.

  12. 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, and then click Next.

  13. On the Operational Data Reports page, click Join the Customer Experience Improvement Program to join CEIP, or click I don't want to join the program at this time to decline participation.

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

  15. On the Operations Manager 2007 Reporting Installed Successfully page, click Finish. 

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