ConfigMgr Reporting Services point
Installing the ConfigMgr Reporting Services point is as simple as adding the a new role to the site server. Before that, ensure the SQL Reporting Services component in SQL 2005 has been added. After all that has been done you will need to copy the reports and here’s how:
Once you have the R2 installed, you will realise an addition to the reporting tree on the left hand pane, Reporting Services. To copy the reports to the Reporting Services, right-click the site server and select Copy Reports to Reporting Services.
Here you will need to specify the server name and the database name to retrieve the reports from. If it is fine, the Test button will be grayed out signaling that the connection is working. Click Next.
Select the type of authentication then click Next.
Select the reports that you would like to copy then click Next.
Click Next in the Security page.
Just click Next at the Summary page.
And the installation begins. View the progress in the page below.
The copying completes. Go ahead and click Close.
Contrary to some understanding, it IS possible to be running both the conventional Reporting Point and the Reporting Services Point concurrently. The Reporting Services Point gives you the following benefits:
- Uses an industry standard reporting system to query the Configuration Manager 2007 database.
- Enables users who are not familiar with Configuration Manager 2007 reporting to generate ad hoc reports.
- Enables users to subscribe to reports; for example, a manager could automatically be e-mailed a report each day, detailing the status of a patch rollout.
- Simplifies the creation of SQL-based reports in Configuration Manager 2007 R2.