SSRS Subscribe Action and SharePoint Permissions

For SQL Server Reporting Services (SSRS) reports there is the ability to create subscriptions. Subscriptions can be scheduled to run on a certain schedule to send emails, export reports to SharePoint document libraries, or save to windows file shares.

Depending on your requirement, you may need to grant or remove access to the subscribe action and can be managed by creating or editing the default SharePoint roles: Read, Contribute, Full Control, etc.

Powershell script to change SSRS Subscription Owner

We leverage Reporting Services subscriptions a lot to deliver reports via email. A problem we run into frequently is when the user who created the subscription loses permission (leaving the company, changing jobs, etc.) then all of the subscriptions they created stop working. This is because they are theĀ Owner of the subscription and SSRS won’t allow the subscription to run when the owner no longer has permission. Here is a quick powershell script you can use to change the owner using the ReportingService2010 web service endpoint.

Top 3 Features missing from SSRS 2008 R2

A list of gripes about features I feel are missing from Microsoft SQL Server Reporting Services 2008 R2.