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)

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

Reporting Services Support Engineer