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

* 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)

http://support.microsoft.com/kb/981052

·         Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en

·         Microsoft SQL Server 2008 Service Pack 2

http://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

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=200fd7b5-db7c-4b8c-a7dc-5efee6e19005&DisplayLang=en

·         SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b3bebf9d-d86d-48cd-94e2-0639a846be80&displaylang=en

Maria Esteban