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.

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.

In this section

Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2016)

Where to find the Reporting Services add-in for SharePoint Products

Install The First Report Server in SharePoint Mode

Install or Uninstall the Reporting Services Add-in for SharePoint

Add an Additional Report Server to a Farm (SSRS Scale-out)

Add an Additional Reporting Services Web Front-end to a Farm

Configure E-mail for a Reporting Services Service Application (SharePoint 2013 and SharePoint 2016)

Provision Subscriptions and Alerts for SSRS Service Applications

Claims to Windows Token Service (c2WTS) and Reporting Services

Next steps

Data Alerts Architecture and Workflow
Data Alert Manager for Alerting Administrators

More questions? Try asking the Reporting Services forum