Jump to content


We use cookies to let you log in, for ads and for analytics. OK

Photo

How can I configure Operations Manager 2007 - Part 3




  • Please log in to reply
1 reply to this topic

#1 anyweb

anyweb

    Administrator

  • Root Admin
  • PipPipPip
  • 7,210 posts
  • Gender:Male
  • Location:Sweden
  • Interests:Deploying Operating systems and more with System Center Configuration Manager

Posted 14 April 2009 - 01:39 PM

Please Note: This guide is not finished yet, while you see this line you can be sure that this post is not complete.


Step 1. Verify Reporting Services in SQL

Note: Failure to do this step will most likely result in SRS Server Validation errors when you try to do Step 2 below.


Verify that the SQL reporting Service is started, open Server Manager, Configuration, Services and check the SQL Reporting Services Service, if it is not started then start it.

sql_reporting_services_service.jpg

You can also check that these are running by opening a web browser and checking the following addresses

http://localhost/Reports

http://localhost/ReportServer

if neither of them respond then either the reporting service is not started or you need to reinstall SQL reporting services.
Microsoft MVP > Enterprise Client Management
My linkedin profile at > linkedin.com
Follow me on Twitter > ncbrady
Follow windowsnoob.com on Twitter > windowsnoob
My blog



#2 anyweb

anyweb

    Administrator

  • Root Admin
  • PipPipPip
  • 7,210 posts
  • Gender:Male
  • Location:Sweden
  • Interests:Deploying Operating systems and more with System Center Configuration Manager

Posted 14 April 2009 - 06:15 PM

Step 2. Install Operations Manager 2007 Reporting

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.


Log on to the SCOM server with Local Administrative Permissions and run SetupOM.exe from the SCOM installation media, click Install Operations Manager 2007 Reporting when the System Center Operations Manager 2007 Setup screen appears.

install.jpg

When the Welcome to the Operations Manager 2007 Reporting Setup Wizard appears, click Next

welcome.jpg

accept the terms in the license agreement and click Next

eula.jpg

In the Product Registration screen, leave the defaults and click Next

product_registration.jpg

At the Custom Setup screen, make sure the location is set to D:\Program Files\System Center Operations Manager 2007 and click Next,

custom_setup.jpg

verify that the This component and all dependent components will be installed on local disk drive is selected for both Data Warehouse and Reporting Services

this_component_and_all_dependent_components.jpg

The installer will do a PreRequisite check and if you get any warnings you will need to read the log by clicking on View Log. (I got a warning about the amount of RAM in my SCOM server, it's a virtual machine with only 512mb ram and SCOM recommends 2GB).

pre_requisite.jpg

On the Connect to the Root Management Server screen, type the name of the Root Management Server and click Next,

opsmgr.jpg

leave the SQL Server Database Instance settings as they are,

sqlserverdatabase_instance.jpg

For the Database and Log file settings, you could consider setting the Database to 5000MB (default is 1000), but as this is a lab, we shall leave it as it is..if you had your DB and LOG files stored on SAN drives it would be here that you could define their location by clicking on the Advanced button. We are just creating a lab so go with the defaults.

database_and_log_file_options.jpg

Review the SQL server reporting services server value (leave it as is) and click next

sql_server_reporting_services_server.jpg

If you get the SRS validation errors then do as follows

1. COPY the ResetSRS.exe file in SupportTool folder of OM 2007 to C:\. (Of
course, you can run this file in OM folder.)
2. Then open the COMMAND PROMP and change your path to C:\.
3. Type "ResetSRS.exe MSSQLSERVER" where MSSQLSERVER is your
SQLINSTANCENAME.
4. Then open Reporting Services Configuration Console in your Program Menu
and select Web Service Identity and on the right side click Apply.
5. Finally, reinstall your reporting service by running OMSetup.exe again.


For the Data Warehouse Write Account screen, type the credentials of the Data Warehouse Write Action Account which we created in Setup Part 1 (OpsMgrDWWAA) and click Next

opsmgrdwwa.jpg

Next we have to se the Data Reader Account so enter the credentials of the Data Reader Account which we created in Setup Part 1 (OpsMgrDRA) and click Next

opsmgrdra.jpg

For Operational Data Reports, leave it on No and click next

operational_data_reports.jpg

And click on Install when the ready to install the program screen appears

ready_to_install_the_program.jpg

and finally after a long install you should see the completing the operations manager reporting components setup wizard screen

completing_the_operations_manager_reporting_components_setup_wizard.jpg

click Finish to exit.
Microsoft MVP > Enterprise Client Management
My linkedin profile at > linkedin.com
Follow me on Twitter > ncbrady
Follow windowsnoob.com on Twitter > windowsnoob
My blog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users