SQL 2012 SP2, Reporting Services, and SharePoint Multi-Tenancy

EDIT: SSRS is officially not supported with multi-tenancy.

SharePoint has a mode known as multi-tenancy. This allows you to have multiple ‘tenants’, or isolated data sets for multiple customers. This mode is similar to how SharePoint Online operates. SQL Server Reporting Services does work in multi-tenant mode, until you install SSRS 2012 Sp2.

While there is an explicit “no support” statement for SSRS 2014, this note does not (yet) exist for SSRS 2012 (or for the installing SSRS on SharePoint 2010 SSRS 2012 and SSRS 2014 articles). With SSRS 2012 pre-SP2, multi-tenancy functions as expected. After applying SP2 (tested up to CU6), the value of Globals.SPSiteSubscriptionId is a null value. This value must be equal to the SPSite.SiteSubscription value in order to function properly.

SSRS2012Sp2MT

 

After opening a case on this, this appears to be a non-tested, unsupported usage scenario for SQL Reporting Services. A bug report has been filed, but my assumption is that the documentation will simply be updated across the board to indicate that there is no support for using SQL Server Reporting Services in SharePoint multi-tenancy.

Update 3/26/2014: This issue appears to be resolved for SQL Server 2012 in Service Pack 2 Cumulative Update 5. It is now possible to open RDL and RSDS files in SharePoint 2010.

8 Comments

  1. Thanks again for your help on this Trevor… If you’re ever over in the UK I owe you a beer!

  2. I have not been able to make it work despite having installed all the CUs and tried everything… I give up. But thank you very much. Your post helped me save a lot of time banging my head on the keyboard for nothing.

    Keep up the good job!

  3. I am deploying Reporting Services 2012 SP3 to a SharePoint 2013 (SP1) App server. Multi-Tenancy is configured.

    I can create reports and data-sources using a Report Library / Report Builder but the process is peppered with exceptions such as:
    ‘ReportingServices.Diagnostic.Utilities.AccessDeniedException’ – The permissions granted to user ‘domain user’ are insufficient

    In ULS each exception is preceded by:
    Level:’Unexpected’ Category: ‘Report Server Catalog’ Message: The current site is not in the SiteSubscription of the context site. SiteSubscription for current site = {guid}, for context site =

    I suspect my issue is the same as this post. Do you know if SQL 2012 SP3 has a patch to fix the above? I am considering reverting to SQL 2012 SP2 with CU5 or even SQL 2012 SP1.

    Your help will really be appreciated. Thanks, Paul

    • I updated the article with a link to the SSRS page. Some time after this post, I ran into the same issue again with a then future patch. Working with Microsoft, we confirmed that SSRS was not supported with multi-tenancy, although at that time the SQL 2012 article did not reflect it. This has since been corrected.

  4. Thanks Trevor, just came across this issue after upgrading to SP3. I guess it’s time to downgrade back to SP1 :)

  5. Anybody know if SSRS works with multi-tenancy in SQL 2014 or SQL 2016?

    Planning on upgrading my multi-tenant farm to SharePoint 2016 and I’m assuming I’ll need to update my Reporting Services for SharePoint Add-In components to a newer version (SQL2014/2016). Anyone tested this with multi-tenancy?

Leave a Reply