Installing SQL Server Reporting Services (SSRS)

The days of ASP reports built on an IIS server are over. An RSP is now the sole means of reporting in CM12. For most admins, installing this role directly on the single primary in their hierarchy will be rather common due to simplicity and financial constraints.

Larger companies that have a Central Administrative Site (CAS) are also likely to install the RSP on the CAS for the simple reason that buying more RAM to get by is cheaper than managing another server for reporting.

Should you wish to offload this role to another server, the major requirements are x64 OS and SQL (IIS not needed). Review the CM supported configurations document at http://technet.microsoft.com/en-us/library/gg682077.aspx for ...

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.