Skip to content

SCOM 2012 – Setup Reporting

February 29, 2012

In my test environment, which runs virtual om Hyper-V i have installed a two server SCOM environment. One server as a dedicated SQL server and the other as a management server with the Operator Console and the Web Console. I described the setup for on this here: SCOM 2012 – Basic Installation.

Install reporting feature on the SQL server:

  1. Run SQL setup from the source:

  2. Setup the support files
  3. In the next step select add features. Select the correct instance if nessecary and click next.
  4. I add the Reporting Services and the Business Inteligence Development Studio (for custom report development) featues to install:


  5. Use a domain account for running the service. I created the SRV_SQL account which is a member of the local administrators.
  6. Further on the only availble option is Install, but do not configure the report server. Click next leave the other options default, check the chosen settings and start the installation.
  7. Now use the Reporting Services Configurations Manager to configure the report server. First setup the database. Creste a new database and use the settings as displayes in the screen:

    Use the (already filled in) SRV_SQL account for running the reporting services.

  8. On both the Web Serice URL and the Report Service URL make no changes and just choose apply. This wat the pre-configured settings are configured. In most cases these will do just fine.
  9. Test the report URL by simply clicking it and provide the account with enough rights. If the SQL reporting home page shows up you have configured it correctly.

     

Install the Agent 

This is pretty straight forward. Install the agent pushing it from the management server or do a manual installation on the dedicated SQL server. I used the push.

Install reporting

  1. Run setup from the SCOM 2012 source on the dedicated SQL server.
  2. Select the report server option and let the software do the prerequisites test. Click next if everything is ok, otherwise solve the issues already!
  3. Specify the management server and the SQL server and/or instance and click next.
  4. Now configure the AD account created for Data Reader Access. I have created the OM_DRA account for this:

  5. Click next and make a selection of your choice on the next two screens. (Microsoft program participation and updates)
  6. Check if the setting you chose are correct and click install.
  7. The configuration will start and should finnish succesfully.

     

 Now when you start (or restart) the oprations console on the management server the reporting button should appear:

You now have the ability to run a lot of reports installed by default. These wil expand more when you start importing management packs.

Advertisements

From → System Center

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: