Configuring Reporting Services

Before you can make the SSRS server an RSP, you need to configure it. This recipe will walk through the process of configuring reporting services and installing the CM12 Reporting Services Point (RSP). You will also learn how to cache reports to eliminate multiple SQL queries against your CM database for the same report.

Getting ready…

In order to configure SSRS, you must first install it. Review the previous recipe for installation information.

How to do it…

From the SSRS box, follow these steps:

  1. Click on the Windows start button and enter Reporting Services Configuration Manager in the search box and hit Enter. Click on Connect.
  2. Under Web Service URL, enter SRSReports for the Virtual Directory and click on Apply.
  3. Under ...

Get Microsoft System Center 2012 Configuration Manager: Administration Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.