First published on TECHNET on Dec 04, 2008
Detailed below are some validation steps that should be completed before attempting to install Operations Manager 2007 Reporting.
During this installation, you are prompted for two accounts: the Data Warehouse Write account and the Data Reader account. These accounts are created as domain user accounts and added to the local Administrators group on the target server.
· Data Warehouse Write account: This account is assigned write permissions on the Data Warehouse database and read permissions on the OperationsManager database.
· Data Reader account: This account is used to define what user SQL Reporting Services uses to run queries against the Operations Manager Reporting Data Warehouse. This account is also used for the SQL Reporting Services IIS application pool account to connect to the RMS.
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.
All permissions are shown below:
Make sure the user running setup has following permissions
User is local administrator (Needed to run MSI, to configure SSRS)
User is Ops Manager Administrator (Needed to configure Reporting roles, creating instances)
User is SysAdmin in Ops DB (Needed to configure dwsynch_users role)
User is SysAdmin in DW DB (Needed to configure OpsMgrWriter, OpsMgrReader roles)
Operations Manager 2007 Reporting requires SQL Reporting Services to be installed and working correctly. Do not run Operations Manager Reporting install until SQL Reporting Services has been validated.
You can validate SQL Reporting Services using the following steps:
To verify that the report server is installed and running
1. Run the Reporting Services Configuration tool, connect to the report server instance you just installed, and review the status indicator for each setting to verify that it is configured.
2. Open the Services window and verify that the Report Server Windows service is running. To view the status of the Report Server Windows service, click
, point to
, and then double-click
. When the list of services appears, scroll to
Report Server (MSSQLSERVER)
. The status should be
3. Open a browser and type the report server URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the report server during setup. By default, the report server virtual directory is named ReportServer. You can use the following URL to verify report server installation: http://
. The URL will be different if you installed the report server as a named instance. For more information about the URL format, see
Configuring Report Server Virtual Directories
To verify that Report Manager is installed and running
1. Open a browser and type the Report Manager URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the Report Manager during setup. By default, the Report Manager virtual directory is Reports. You can use the following URL to verify Report Manager installation: http://
2. Use Report Manager to create a new folder or upload a file to test whether definitions are passed back to the report server database. If these operations are successful, the connection is functional.