Installing SQL Server Reporting Services - SSRS

An RSP is the sole means of reporting in CM. For most admins, installing this role directly on the single primary in their hierarchy will be rather common simply out of 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 configuration documents at https://technet.microsoft.com/en-us/library/mt589499.aspx for up-to-date information for required OS and SQL versions. ...

Get Microsoft System Center Configuration Manager Cookbook - Second Edition 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.