Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

 

Reporting Services report servers can be installed in SharePoint mode and integrated with a SharePoint deployment. Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. This topic summarizes the supported combinations. Reporting Services SharePoint integration is a result of the combination of the following:

  • A version of a Reporting Services report server configured for SharePoint mode.

  • A SharePoint product.

  • The Reporting Services add-in for SharePoint products, which you install on the SharePoint servers.

Applies to: SharePoint 2013 | SharePoint 2010 | SharePoint 2007

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 server

Add-in

SharePoint version

Supported

1

SQL Server 2016 Community Technology Preview 2 (CTP2)

SQL Server 2016 Community Technology Preview 2 (CTP2), SQL Server 2014, SQL Server 2012 SP1

SharePoint 2013 (*)

Yes

2

SQL Server 2014

SQL Server 2014

SharePoint 2013

Yes

3

SQL Server 2014

SQL Server 2014

SharePoint 2010

Yes

4

SQL Server 2012 SP1

SQL Server 2014 and SQL Server 2012 SP1

SharePoint 2013

Yes

5

SQL Server 2012 and SQL Server 2012 SP1

SQL Server 2014

SharePoint 2010

Yes

Exception: Power view integration is not supported.

6

SQL Server 2012

SQL Server 2012

SharePoint 2010

Yes

7

SQL Server 2008 R2

SQL Server 2014

SharePoint 2010

Yes

8

SQL Server 2008 R2

SQL Server 2012 and SQL Server 2012 SP1

SharePoint 2010

Yes

9

SQL Server 2008 R2

SQL Server 2008 R2

SharePoint 2010

Yes

10

SQL Server 2008 R2

SQL Server 2008 SP2

SharePoint 2007

Yes

11

SQL Server 2008 SP2

SQL Server 2008 R2

SharePoint 2010

Yes

12

SQL Server 2008 SP2

SQL Server 2008 and SQL Server 2008 SP2

SharePoint 2007

Yes

(*) SharePoint 2013 is supported on Windows Server 2012 or newer. For more information on SQL Server 2016 Community Technology Preview 2 (CTP2) supported operating systems, see Hardware and Software Requirements for Installing SQL Server 2016.

For more information on Reporting Services features and report server modes, see Reporting Services Report Server.

Additional Notes:

  • 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.

Community Additions

ADD
Show:
© 2015 Microsoft