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:





Login as DomainSQL Service



Go to Start Programs  Microsoft SQL Server 2008, Configuration Tools and click Reporting Services Configuration Manager.



Enter SQL server or SQL Virtual Server name as Machine Name. Select Instance Name and click Connect.



Under Report Server Status should show as Started. Then click Web Service URL on left hand side pane.



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.




Click Database on left hand side pane, confirm Reporting Database creation, or create a new Reporting Database, and then click Apply



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




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

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.