Operations Manager 2007 R2 Installation and Configuration “step by step” – Part 5 “Configuring SQL Reporting Service”

 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. clip_image003
2. Enter SQL server or SQL Virtual Server name as Machine Name. Select Instance Name and click Connect. clip_image005
3. Under Report Server Status should show as Started. Then click Web Service URL on left hand side pane. clip_image007
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. clip_image009


5. Click Database on left hand side pane, confirm Reporting Database creation, or create a new Reporting Database, and then click Apply clip_image013
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 clip_image015


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:


Leave a Reply