This documentation is archived and is not being maintained.

Deploying Reporting on Windows Server 2008 and SQL Server 2008

Updated: September 20, 2010

Applies To: Operations Manager 2007 R2, Operations Manager 2007 SP1

In this scenario, the Data Warehouse and the Operations Manager Reporting components are installed on separate servers. The Data Warehouse database is installed in the SQL Server Cluster and the Reporting services are installed on a stand-alone server that is hosting SQL Server Database and SQL Reporting Services. For a listing of the top 10 Reporting Services installation issues and their resolutions see:

Although SQL Reporting Services is installed on the stand-alone server, Operations Manager Reports are not accessed on this server; instead, they are accessed in the Reports view in the Operations console. If you want to access published reports via the Web console, then you must install the Operations Manager 2007 Web console component on the same computer as Operations Manager 2007 Reporting services.

Installation overview

  1. Run Install Operations Manager 2007 R2 Reporting on the stand-alone Reporting server, and choose to install the Reporting Server component only.

  2. Verify the health of Operations Manager 2007 Reports.

Before you start

  1. On the stand-alone server that is to be used for Reporting Services, add the following accounts and group to the Local Administrators group:

    • Domain MSAA

    • Domain SQL Service account

    • Domain SDK and Config Service account

    • Domain Operations Manager Administrators security group

    • Domain Data Reader and Data Writer accounts

    Before you continue with 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 OperationsManager database and the Reporting Data Warehouse database. Otherwise, setup fails and all changes are rolled back, which might leave SQL Reporting Services in an inoperable state.

    Both the Data Warehouse Write Account and the Data Reader account must have logon locally rights on this server.

    The account that you use to run the Operations Manager 2007 Reporting installation must be a member of the following groups and roles.

    • Local Administrator – this is required by the Operations Manager 2007 Reporting installation and for configuring SQL Server Reporting Services.

    • Operations Manager Administrator role – this is required for configuring reporting roles and creating reporting instances.

    • SQL SysAdmin for the OperationsManager database – this is required for configuring dwsynch_users role.

    • SQL SysAdmin for the Data Warehouse database – this is required for configuring OpsMgrWriter and OpsMgrReader roles.

  2. Install SQL Server 2008 on the stand-alone server with the SQL Server Database Services, Reporting Services in Native mode (not SharePoint Integrated mode), and Workstation components, Books Online and development tools options.

  3. Confirm the existence of the ReportServer and ReportServerTempDB databases in SQL Server Management Studio on the stand-alone server. Click Start, point to Programs, point to Microsoft SQL Server 2008, point to SQL Server Management Studio, and connect to the default database instance. Open the Databases node and look for the two Reporting Services databases.

  4. Confirm the correct configuration of SQL Server 2008 Reporting Services. Click Start, point to Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and click Reporting Services Configuration Manager. Connect to the instance that you installed Reporting Services on.

  5. In the left pane, select the <servername>\SQLinstance. This displays the Report Server status in the results pane. Ensure that the Report Server Status is Started.

  6. In the left pane select Scale-out Deployment and ensure that the Status column has the value of Joined.

  7. If Report Server is not started and the Scale out Deployment is not joined, then check the configuration of Service Account, Web Service URL, and Database.

  8. Confirm that the SQL Server Reporting Services service is running. In Server Manager, expand the Configuration container and select Services.

  9. In the Name column, find the SQL Server Reporting Services instance service and confirm that its status reads Started and that its Startup Type is Automatic.

  10. Confirm that the Report Server Web site is functioning and accessible by browsing to http://servername/reportserver<$instance>. You should see a page with the <servername>/ReportServer<$INSTANCE> and the text, Microsoft SQL Server Reporting Services Version ##.#.####.## where the # is the version number of your SQL Server installation.

  11. Confirm the correct configuration of Report Manager Web site by opening Internet Explorer and browsing to http://<servername>/reports<instance>.

  12. When you are in the Report Manager Web site, click New Folder to create a new folder. Enter a name and description, and then click OK. Ensure that the new, created folder is visible on the Report Manager Web site.

For more information about how to verify a SQL Server Reporting Services installation see:

Installing Operations Manager Reporting on a Stand-Alone Server

In this procedure, you install the Operations Manager Reporting component on the stand-alone Reporting server. Due to changes that the Operations Manager 2007 Reporting component makes to SQL Server Reporting Services security, no other applications that make use of SQL Server Reporting Services can be installed on this SQL Server instance.

To check for Operations Manager 2007 Reporting component prerequisites

  1. Log on to the server with the Operations Administrator account credentials.

  2. From your Operations Manager 2007 installation media, start SetupOM.exe to start the System Center Operations Manager 2007 R2 Setup on the Start page.

  3. Under Prepare, click Check Prerequisites to start the Prerequisite Viewer.

  4. In the Components box, select the Reporting component, and then click Check.

    When the Reporting component is selected, the Prerequisite Viewer checks for presence of Windows Server 2003 SP1, Microsoft SQL Server 2005 Reporting Services Service Pack 1 or SQL Server 2008 with SP1 and SQL Server 2008 Reporting Services with SP1, .NET Framework version 2.0, .NET Framework version 3.0 components.

    The results are displayed at the bottom of the Prerequisite Viewer. If there are any deficiencies, they are marked either as Warning or as Failed. Warnings can be ignored at the risk of degraded performance or other issues; Failed prerequisites must be fixed before the installation can proceed. You can close the Prerequisite Viewer, fix the items and rerun the Prerequisite Viewer checks as many times as it is necessary until a status of Passed is achieved on all items.

  5. When you are done with the Prerequisite Viewer, click Close.

To install Operations Manager 2007 R2 Reporting component

  1. Log on to the server with the Operations Manager Administrator account.

  2. On your installation media, open SetupOM.exe. This starts the System Center Operations Manager 2007 R2 Setup Wizard on the Start page.

  3. In the Install area, click the Install Operations Manager 2007 R2 Reporting link.

  4. On the Welcome page, click Next.

  5. On the End-User License Agreement page, select the I accept the terms in the license agreement option.

  6. On the Product Registration page, enter the appropriate value in the User Name and Organization fields. Enter the 25-digit CD Key, and then click Next.

  7. On the Custom Setup page, ensure that the Reporting Server component is set to This component, and all dependent components, will be installed on the local disk drive, and that the Data Warehouse component is set to This component will not be available. To change the installation directory, click Browse, enter the appropriate path and folder name, and then click Next.

  8. If the Prerequisite Check page appears, and if all prerequisites have passed, click Next.

  9. On the Connect to the Root Management Server page, enter a value in the name field of the RMS Network Name Cluster resource, and then click Next.

  10. On the Connect to the Operations Manager Data Warehouse page, in the SQL Server Database instance field, enter the value that is in the name field of the SQL Network Name cluster resource. In the SQL database name field, ensure that OperationsManagerDW is there. Check that the SQL Server Port field is set to 1433, unless you have previously configured a different port for SQL Server communications, or, if your SQL Server installation is installed into a named instance and is using a dynamic port, enter those values, and then click Next.

  11. On the SQL Server Reporting Services Instance page, select the Reporting Services server instance name from the drop-down list, and then click Next.

    Installing Operations Manager 2007 Reporting Services integrates the security of the instance of SQL Reporting Services with the Operations Manager role-based security. Do not install any other Reporting Services applications in this same instance of SQL Server.

  12. On the Data Warehouse Write Account page, enter the Data Writer account credentials, and then click Next.

  13. On the Data Reader Account page, enter the Data Reader account credentials, and then click Next.

  14. On the Operational Data Reports page, optionally select whether to join the program, and then click Next.

  15. On the Microsoft Update page, optionally select whether to use Microsoft Update.

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

  17. When the installation is complete, click Finish.

To confirm the health of Operations Manager reports

  1. Log on to a management server with an Operations Administrator role account and start the Operations Console.

  2. In the Operations Console, select Reporting (on the bottom, left side of the console).

  3. Under Reporting, select the Microsoft ODR Report Library, and then double-click any of the reports listed. By default, you should see the Management Group, Management Packs, and Most Common Alerts reports. This causes the selected report to be generated and be displayed in a new window.

    Selecting the management packs report is particularly useful at this point because it provides you with a full inventory of the management packs that have been installed on your server.

  4. Close the report window.

Uninstalling Operations Manager Reporting Services

You can uninstall Operations Manager Reporting services through the Add or Remove Programs tool. If you do, you must also run the ResetSRS.exe tool found in the SupportTools folder of the Operations Manager installation media.

To uninstall Operations Manager 2007 Reporting Services component

  1. Log on to the Reporting Server with the Operations Manager Administrator account.

  2. Click Start, point to Control Panel, and then click Programs and Features.

  3. From the list of currently installed programs, select System Center Operations Manager 2007 R2 Reporting Server, and then click Remove. This uninstalls Operations Manager Reporting Server, but it does not uninstall SQL Server 2008 Reporting Services.

  4. When the uninstall is complete, copy the ResetSRS.exe tool to the root of the local hard drive.

  5. Open a Command Prompt windows as an Administrator and change directories to the root of the local hard drive or wherever you copied the ResetSRS.exe tool, and then type c:\resetSRS.exe <SQLINSTANCENAME> where SQLINSTANCENAME is the name of the instance of SQL Server that SQL Reporting Services was installed in. If you installed in the default instance, use MSSQLSERVER for the <SQLINSTANCENAME> value.