Supported Combinations of SharePoint and Reporting Services Components
SQL Server 2008 SP2 updated SharePoint integration for both Reporting Services report servers and the Reporting Services add-in for SharePoint 2007 products.
Supported Combinations of SharePoint and Reporting Services Components
The following list summarizes recommendations for Reporting Services integration with SharePoint:
For SharePoint 2007, always use the SQL Server 2008 Reporting Services add-in for SharePoint 2007.
For SharePoint 2010, always use the SQL Server 2008 R2 Reporting Services add-in for SharePoint 2010 products.
SQL Server 2008 R2 report servers are supported with both SharePoint 2007 and SharePoint 2010.
SQL Server 2008 report servers are supported with SharePoint 2007.
SQL Server 2008 SP1 CU #8 and higher report servers are supported with SharePoint 2007 and SharePoint 2010.
The following table summarizes the supported combinations of report server, the Reporting Services add-in for SharePoint products, and SharePoint products.
Report server |
Add-in |
SharePoint version |
|---|---|---|
SQL Server 2008 R2 |
SQL Server 2008 SP2 |
SharePoint 2007 |
SQL Server 2008 (rtm-SP2) |
SQL Server 2008 SP2 |
SharePoint 2007 |
SQL Server 2008 SP2 |
SQL Server 2008 R2 |
SharePoint 2010 |
SQL Server 2008 SP2 |
SQL Server 2008 |
SharePoint 2007 |
SQL Server 2008 SP1 Cumulative Update #8 |
SQL Server 2008 R2 |
SharePoint 2010 |
SQL Server 2008 SP1 Cumulative Update #8 |
SQL Server 2008 |
SharePoint 2007 |
SQL Server 2008 to SQL Server 2008 SP1 Cumulative Update #7 |
SQL Server 2008 |
SharePoint 2007 |