Team blog of MCS @ Middle East and Africa

This blog is created by Microsoft MEA HQ near shoring team, and it aims to share knowledge with the IT community.With its infrastructure and development sides,It brings to you the proven best practices and real world experiences from Subject Matter Experts
Follow Us On Twitter! Subscribe To Our Blog! Contact Us

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

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

  • Comments 3
  • Likes

 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 Domain\SQL 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

clip_image011

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

clip_image017

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:

Comments
  • <p>Part 6 released,</p> <p>Part 7 released,</p> <p>Part 8 released,</p>

  • <p>Hi Meged,</p> <p>My I know, do you have the steps fro installing Reporting Server as I encounter an error &quot;could not verify if current user is in sysadmin role &quot;</p> <p>Thanks,</p>

  • <p>very helpful stuff.. </p> <p>when would you upgrade this environment to scom 2012 ?</p>

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment