Enabling Reporting Services

Enable the ability to report back telemetry, statistics, etc... This is good for inventory or a form of asset management. For a complete set up guides, please refer to here and here.

  1. Install the Report Builder component on SCCM
  2. Creating the DB's might require Local Administrator (not domain) access if you received auth. failures

For troubleshooting the Reporting Services, please refer to this site.

  1. Create a discrete SQL User for Reporting Services, granting them 'public' and 'smsschm_users' access to the CM DB, and ReportServer DB. Use the same account as the Reporting Services account too.
  2. Then install the Reporting Services role on SCCM. After the install, the reports under Monitoring > Reports, the reports will take moments to populate.