Friday, September 19, 2008 3:00 PM
Brian S. Tucker
Configuring SCCM R2 SQL Reporting Services Role
Another great new feature of R2 is the addition of SQL Reporting Services. This rich new tool will allow you to have greater speed and flexibility with your reports. Not only can you convert your reports that come with the standard version of SCCM SP1, but you can also make new reports much easier than previous methods. Since Reporting Services also has a IIS website associated to it, users can subscribe to specific reports and have the report emailed to them rather than going to the website. This is a great advantage with Reporting Services. The video demonstrates how to setup Reporting Services in SQL 2005, add the role in the SCCM admin Console, copy the current reports into Reporting Services and takes a look at the new web page. While I do not demonstrate in this video how to make a new report, simply right click the server name and choose “New Report” and you will see how easy it is to create dynamic reports which were much more cumbersome previously. I also strongly suggest you refer to Microsoft’s SCCM Library for SQL Reporting Services in R2. NOTE: Do not ever use SQL 2008 with SCCM 2007. The next version of SCCM is designed to function with SQL 2008.
Click the image below to watch the video. Enjoy!
Filed under: SCCM 2007, CM 2007 Video Series, CM 2007, Level 5, SCCM SP1, SCCM R2 SQL Reporting