Install Reporting Services 2016 in SharePoint mode
APPLIES TO: ✔️ SQL Server Reporting Services (2016) ❌ SQL Server Reporting Services (2017) ✔️ SharePoint ❌ Power BI Report Server
For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.
SQL Server Reporting Services in SharePoint, enables report creation and viewing in document libraries, Reporting Services subscription delivery of reports through email, Power View, data alerting, and report management features, all in a deployment of based of Microsoft SharePoint. For more information regarding features in SharePoint mode, see the section "Feature Support and Behavior Differences by Server Mode" in Reporting Services Report Server.
Reporting Services integration with SharePoint is no longer available after SQL Server 2016. Power View support is no longer available after SQL Server 2017.
There are two core Reporting Services components to install for Reporting Services in SharePoint mode:
|Report Server: The Microsoft SQL Server Reporting Services report server installed in SharePoint Mode||The report server handles the data and report processing and rendering as well subscription and Data Alert processing. The SharePoint mode report server is designed and installed as a SharePoint Shared Service.
How: Use the SQL Server installation media to install the report server.
|Add-in: The Microsoft SQL Server Reporting Services add-in for SharePoint products, rssharepoint.msi.||The add-in installs the Reporting Services user interface (UI) pages and features on a SharePoint web front-end server. The UI features include Power View, administration pages in SharePoint Central Administration, feature pages used within SharePoint document libraries, and Reporting Services Data Alerting pages.
How: The add-in can be installed from either a Web download or the SQL Server installation media. For more information, see Where to find the Reporting Services add-in for SharePoint Products.
In this section
More questions? Try asking the Reporting Services forum