Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2012)
Reporting Services report servers can be installed in SharePoint mode and integrated with a SharePoint deployment. In SQL Server 2012 The 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.
Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products.
Supported Combinations of SharePoint and Reporting Services Components
The following table summarizes the supported combinations of report server, the Reporting Services add-in for SharePoint products, and SharePoint products.
Supported Combinations
Report server |
Add-in |
SharePoint version |
Supported |
|
|---|---|---|---|---|
1 |
SQL Server 2012 SP1 |
SQL Server 2012 SP1 |
SharePoint 2013 |
Yes |
2 |
SQL Server 2012 SP1 |
SQL Server 2012 SP1 |
SharePoint 2010 |
Yes |
3 |
SQL Server 2012 |
SQL Server 2012 |
SharePoint 2010 |
Yes |
4 |
SQL Server 2008 R2 |
SQL Server 2012 and SQL Server 2012 SP1 |
SharePoint 2010 |
Yes |
5 |
SQL Server 2008 R2 |
SQL Server 2008 R2 |
SharePoint 2010 |
Yes |
6 |
SQL Server 2008 R2 |
SQL Server 2008 SP2 |
SharePoint 2007 |
Yes |
7 |
SQL Server 2008 SP2 |
SQL Server 2008 R2 |
SharePoint 2010 |
Yes |
8 |
SQL Server 2008 SP2 |
SQL Server 2008 and SQL Server 2008 SP2 |
SharePoint 2007 |
Yes |
For more information on Reporting Services features and report server modes, see Reporting Services Report Server (SSRS).
Additional Notes:
SharePoint 2013 requires the Reporting Services add-in version of SQL Server 2012 SP1 or later.
Power View integration with SharePoint 2013 requires the SQL Server 2012 SP1 or later of the add-in.
Power View integration with SharePoint 2010 requires the SQL Server 2012 or later of the add-in.
SharePoint 2010 requires the Reporting Services add-in version of SQL Server 2008 R2 or later.
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.
See Also
Concepts
Where to find the Reporting Services add-in for SharePoint Products