Monday, June 11, 2012

SQL 2012 SSRS Sharepoint 2012 Integration Corrupt Data Driven Subscriptions



      We recently upgraded from SQL SSRS 2008 R2 Sharepoint 2010 Integration Mode to  SQL SSRS 2010 Sharepoint 2010 Integration Mode. After making this upgrade we were no longer able to edit any of the Data Driven subscriptions. The reason for this is that SSRS 2010 Data Driven subscriptions require a few additional nodes than 2008 R2. If you edit the subscriptions in the ReportServer.dbo.Subscriptions table you will be able to edit via the SharePoint/ReportServer UI. 

F    Follow the below steps and script.

1.       Find the SubscriptionID
2.       Update the SubscriptionID variable
3.       Run the Subscription update
4.       Edit the Subscription in SharePoint to confirm


Due to formatting I had to upload the script in a file:
http://fsugeiger.com/misc/codesamples/sqlssrssubscriptionfix.txt






2 comments:

Bryan K Geiger said...
This comment has been removed by the author.
Bryan K Geiger said...
This comment has been removed by the author.

Post a Comment