Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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