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 CM 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, Installing SQL Server Reporting Services - SSRS 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 Database, click on Change Database. Click on Next to create a new report server database.

4. Under Database Server, click on Test Connection. If you don't have permissions, you missed the preceding step...