Compatibility and Supported combinations for the integration of Reporting Services 2008 with SharePoint 2007 and 2010
We get many cases trying to configure Reporting Services with SharePoint. I am creating this post because some of the errors on the configuration can be avoided by choosing the right versions of the Add in (and service packs) depending on the versions of RS and SharePoint you are trying to integrate.
The following table shows the different combinations
Report Server |
Add-in |
SharePoint version |
SQL Server 2008 R2 |
SQL Server 2008 SP2 |
SharePoint 2007 |
SQL Server 2008 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 #8 * |
SQL Server 2008 |
SharePoint 2007 |
* SP1 Cumulative Update #8 or Higher (SP2)
You can find the links bellow:
· (Cumulative update package 8 for SQL Server 2008 Service Pack 1 enables Microsoft SQL Server 2008 SP1 Reporting Services report server to integrate with Microsoft SharePoint 2010 products)
https://support.microsoft.com/kb/981052
· Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies
· Microsoft SQL Server 2008 Service Pack 2
https://www.microsoft.com/downloads/en/details.aspx?FamilyID=8FBFC1DE-D25E-4790-88B5-7DDA1F1D4E17
· Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
· SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010
Maria Esteban
Reporting Services Support Engineer