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.

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.