Home » sharepoint » SharePoint 2013 » Key Administrator Controls in SharePoint 2013 for Reporting Services

Key Administrator Controls in SharePoint 2013 for Reporting Services

In Reporting Services in SharePoint 2013 Part 2, Jason Himmelstein presents some of the controls available to administrators to manage the Reporting Services service for SharePoint Server 2013.

The intended audience for this video are SharePoint Administrators. The video is presently available to any/all subscribers to SharePoint-Videos.com. If past experience can be used as an accurate indicator, the video will likely be included in a specialized training set for purchase and local viewing by individuals or groups.

Administrators experienced with older versions of Reporting Services for SharePoint will likely look favorably on the new access method to this feature as a service. There is no need, any longer, to “toggle” between two separate user interfaces.

These controls include job management, which can be handy when long jobs are running. Encryption keys can be backed up, and, as Jason notes, should be backed up: “If you don’t have a backup of your encryption key, and you lose your SSRS instances, you will not be able to get back all those RDLs out there and [already] created”. He demonstrates how to back up the key in this video and how to restore it, if required. Administrators can also change encryption keys from Central Administration, and even delete them.

An Execution Account is provided for stress testing. Finally, administrators looking to enable email alerts for this service will need to set their SMTP server through the eMail settings for this service through Central Administration. The SQL Server agent must be activated in order to use the “Provision Subscriptions and Alert – SSRS” capability. On this latter point, Jason demonstrates how to download the script automatically generated by the server and, subsequently, to load it via SQL Server Studio. An appropriate set of credentials is required to generate the script. An administrator must run the script prior to “grabbing” the appropriate rights to provision subscriptions and alerts. Once the privileges are in place, then an administrator will be capable of publishing alerts.

Ira Michael Blonder

© Rehmani Consulting, Inc. & Ira Michael Blonder, 2013 All Rights Reserved