Jump to content


  • 0
anyweb

How can I configure Operations Manager 2007 - Part 3

Question

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.

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.