Install Reporting Services 2016 in SharePoint mode

مقالة
09/25/2024

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 What is SQL Server 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.

Note

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:

Installation	Description
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.

Installation

Description

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.