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

 

Updated: October 7, 2016

Applies To: SQL Server 2016

needhelp Need help? MSDN forum | stackoverflow | Log an issue or suggestion at Microsoft Connect

A Reporting Services report server installed in SharePoint mode requires a version of SharePoint and the Reporting Services add-in (rsSharePoint.msi) for SharePoint products, which you install on the SharePoint servers. This topic summarizes the supported combinations.

The following table summarizes the supported combinations of report server, the Reporting Services add-in for SharePoint products, and SharePoint products. Combinations that are not list in the following table are not supported

Supported Combinations

Report serverAdd-inSharePoint version
1SQL Server 2016SQL Server 2016SharePoint 2016
2SQL Server 2016SQL Server 2016SharePoint 2013
3SQL Server 2014SQL Server 2014SharePoint 2013
4SQL Server 2014SQL Server 2014SharePoint 2010
5SQL Server 2012 SP3SQL Server 2014 and SQL Server 2012 SP3SharePoint 2013
6SQL Server 2012 SP2SQL Server 2014 and SQL Server 2012 SP2SharePoint 2013
7SQL Server 2012 SP1SQL Server 2014 and SQL Server 2012 SP1SharePoint 2013
8SQL Server 2012 and SQL Server 2012 SP1*SQL Server 2014SharePoint 2010
9SQL Server 2012SQL Server 2012SharePoint 2010
10SQL Server 2008 R2SQL Server 2014SharePoint 2010
11SQL Server 2008 R2SQL Server 2012 and SQL Server 2012 SP1SharePoint 2010
12SQL Server 2008 R2SQL Server 2008 R2SharePoint 2010
13SQL Server 2008 R2SQL Server 2008 SP2SharePoint 2007
14SQL Server 2008 SP2SQL Server 2008 R2SharePoint 2010
15SQL Server 2008 SP2SQL Server 2008 and SQL Server 2008 SP2SharePoint 2007

*Exception: Power view integration is not supported.

For links to the add-in download pages, see Where to find the Reporting Services add-in for SharePoint Products.

Additional Notes:

  • Be sure to upgrade to upgrade all of the SharePoint servers within the farm. This includes the App and Web Front End servers.

  • SharePoint 2016 support, including Power view integration, requires the Reporting Services report server and the Reporting Services add-in version of SQL Server 2016 or later.

  • SharePoint 2013 support, including Power view integration, requires the Reporting Services report server and the Reporting Services add-in version of SQL Server 2012 SP1 or later.

  • Power View was introduced in SQL Server 2012. Therefore, Power View integration with SharePoint 2010 requires the SQL Server 2012 or later of the add-in.

  • The SQL Server 2008 R2 Add-In is not supported by SQL Server 2012 (or later) report servers. The SharePoint 2010 prerequisite installer automatically installs the SQL Server 2008 R2 Add-In. It must be uninstalled before installing newer versions of the add-in. In place upgrade of the add-in is not supported.

  • Upgrade: SharePoint 2010 with the Reporting Services Add-In installed, cannot be upgraded in-place to SharePoint 2013. SharePoint 2013 requires SQL Server 2012 SP1 or later of the Reporting Services add-in and report server. For more information on upgrade, see Upgrade and Migrate Reporting Services.

Where to find the Reporting Services add-in for SharePoint Products
Features Supported by the Editions of SQL Server 2016
Hardware and Software Requirements for Installing SQL Server 2016

Community Additions

ADD
Show: