Unable to create or edit SSRS 2012 subscriptions on reports stored in SharePoint 2013 document library

On a recent SharePoint 2010/2013 deployment we ran into some strange issue during the migration of SharePoint 2010 sites that utilized SQL Reporting Services 2008 R2 over to a SharePoint 2013 and SSRS 2012 environment.

We had a few problems after the migration

• Unable to create subscriptions on new reports
• Unable to view subscription information on existing reports
• Unable to set the output location of the subscription to a SharePoint document library

So when the users would go in to create new subscriptions on the migrated reports and it would just fail with an error that the SharePoint location did not exist. Users were also unable to view or create subscriptions on existing SSRS reports. When they would try to go into the subscriptions an error would be thrown on the item.

We started working the first issues by taking SQL traces as subscriptions were being created we discovered that there was a missing SQL permission that was required for this. The DBA created the new custom role and we were then able to set and view subscriptions on reports.

With that resolved we moved onto the last issue. When you would create a new subscription and select the output location to be a SharePoint document library it would throw an error that it could not be set. After much digging and beating my head against the wall I ended up having to open up a support case with Microsoft on the issue as I could find nothing further about this problem.

After some time on the phone with them troubleshooting they discovered some notes about this issue being resolved by a SQL 2012 CU.  We applied the SQL Cumulative Update 5 to the SQL server as well as all SharePoint servers in the farm since they all have the SQL client for SharePoint installed. After doing this on all the servers in the farm we tested and were then able to set the output location to the document library.

In the article for the CU it had an item mentioned about SSRS subscriptions, but the behavior is different then we were seeing.

SQL CU5

http://support.microsoft.com/kb/2777772

1062516

2785699

FIX: Error message when you view SharePoint integrated data-driven subscriptions after you upgrade to SSRS 2012