Reporting Services Feature Pack

In order to use SQL Server Reporting Services in a multi-tenant situation, follow the standard setup for SSRS. That is, install SSRS on a SharePoint server, start the Service Instance, create a Service Application and Proxy, and assign the Proxy to the Web Application hosting your multi-tenant sites.

For the Feature Pack, there are only two Features that are required to enable Reporting Services support. In this example, these Features are added to an existing Feature Pack.

$fp = Get-SPSiteSubscriptionFeaturePack -Identity GUID
Add-SPSiteSubscriptionFeaturePackMember -Identity $fp -FeatureDefinition ReportServer
Add-SPSiteSubscriptionFeaturePackMember -Identity $fp -FeatureDefinition ReportServerItemSync
Set-SPSiteSubscription -Id $SubscriptionId -FeaturePack $fp
New-SPSite -Url http://siteUrl -OwnerAlias "domain\username" -Template "STS#0" -SiteSubscription $sub
iisreset

That’s it. Now the Site Collection “Report Server Integration Feature” and Web “Report Server File Sync” features can be enabled and the SSRS Content Types will be available.

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.