In this post series I am going through step by step into System Center Operations Manager 2007 R2 starting from “Pre-Build”, then I continued with “Installing Operations Manager Database”, followed by another post “Installing Root Management Server” and then “Configure GPO for SCOM”,
Now in this post I will cover Configuring SQL Reporting Service that is required for SCOM Reporting as a step before Installing Data Warehouse Database, and what you should remember is that to install SQL Reporting Service you will need IIS to be installed before install SRS.
Steps are as the following:
| Step | Description | Screenshot |
| Login as DomainSQL Service | ||
| 1. | Go to Start Programs Microsoft SQL Server 2008, Configuration Tools and click Reporting Services Configuration Manager. |  |
| 2. | Enter SQL server or SQL Virtual Server name as Machine Name. Select Instance Name and click Connect. |  |
| 3. | Under Report Server Status should show as Started. Then click Web Service URL on left hand side pane. |  |
| 4. | Confirm that Report Server Web Service URL is working by click on blue URL, then click Advanced to confirm Web Site Configuration, and then click ok to close Advanced Window. | 
|
| 5. | Click Database on left hand side pane, confirm Reporting Database creation, or create a new Reporting Database, and then click Apply |  |
| 6. | Click Report Manager URL on left hand side pane, and confirm Report Manager URL and it’s Virtual Directory is working by click on the blue Report Manager URL, then click Advanced to confirm Report Manager URL site settings, and then click ok to close Advanced Window | 
|
| 7. | Confirm all other optional settings and confirm that SQL 2008 Reporting service is healthy and ready and close SQL 2008 Reporting Configuration Manager, then start Data Warehouse Database Installation in next step. |
In the coming post I will go through the steps to install Data Warehouse Database for Reporting…
Related Posts:
- Part 1 “Pre-Build” can be found here http://blogs.technet.com/b/meamcs/archive/2011/01/09/operations-manager-2007-r2-installation-and-configuration-part1-pre-build.aspx
- Part 2 “Installing Operations Manager Database” can be found here http://blogs.technet.com/b/meamcs/archive/2011/01/09/operations-manager-2007-r2-installation-and-configuration-part2-installing-operations-manager-database.aspx
- Part 3 “Installing Root Management Server” can be found here http://blogs.technet.com/b/meamcs/archive/2011/01/10/operations-manager-2007-r2-installation-and-configuration-step-by-step-part3-installing-root-management-server.aspx
- Part 4 “Configure GPO for SCOM” can be found here http://blogs.technet.com/b/meamcs/archive/2011/01/10/operations-manager-2007-r2-installation-and-configuration-step-by-step-part4-configure-gpo-for-scom.aspx
- Part 5 “Configuring SQL Reporting Service” can be found here http://blogs.technet.com/b/meamcs/archive/2011/05/16/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-5-installing-sql-reporting-service.aspx
- Part 6 “Installing Data Warehouse Database” can be found here http://blogs.technet.com/b/meamcs/archive/2011/08/14/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-6-installing-data-warehouse-database.aspx
- Part 7 “Installing Audit Collection Service” can be found here http://blogs.technet.com/b/meamcs/archive/2011/08/15/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-7-installing-audit-collection-service.aspx
- Part 8 “Download and Import Management Pack” can be found here http://blogs.technet.com/b/meamcs/archive/2011/08/16/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-8-download-and-import-management-pack.aspx
- Part 9 “Discover Windows Computer and Deploy Agents” can be found here http://blogs.technet.com/b/meamcs/archive/2011/08/27/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-9-discover-windows-computer-and-deploy-scom-agents.aspx
- Part 10 “Discover Unix/Linux Servers and Deploy Agents” can be found here http://blogs.technet.com/b/meamcs/archive/2011/08/29/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-10-discover-unix-linux-servers-and-deploy-agents.aspx
- Part 11 “Configure Notification” can be found here http://blogs.technet.com/b/meamcs/archive/2011/09/03/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-11-configure-notification.aspx
- Part 12 “Configure Audit Collection Service” can be found here http://blogs.technet.com/b/meamcs/archive/2011/09/17/operations-manager-2007-r2-installation-and-configuration-step-by-step-part-12-configure-audit-collection-service.aspx
