Reporting Services Add-in Supports Integrating SQL Server 2008 R2 Report Servers with SharePoint 2007
The SQL Server 2008 Service Pack 2 (SP2) add-in for SharePoint 2007 products should be installed with SharePoint 2007 products only. It allows you to integrate your SharePoint 2007 environment with SQL Server 2008 R2 report servers and SQL Server 2008 report servers. Previous versions of the add-in for SharePoint 2007 products did not support integration with SQL Server 2008 R2 report servers. When integrated with a SQL Server 2008 R2 report server, you will be able to use some of the new features of the SQL Server 2008 R2 report server. The new features supported include the following:
Support for Report Part Gallery, shared datasets, and shared report items. For more information, see Working with Report Parts and Datasets .
SQL Server 2008 R2 Report Builder 3.0.
ATOM feed renderer. You can generate Atom-compliant data feeds from reports, and then use the data feeds in applications, such as the SQL Server 2008 R2 PowerPivot client, that can consume data feeds. For more information, see the “Rendering Reports to Data Feeds” section in What's New (Reporting Services) and How to: Generate Data Feeds from a Report.
This version of the add-in supports SQL Server 2008 report servers; however the new features are only supported when connecting to SQL Server 2008 R2 report servers. Additionally, installation of the SQL Server 2008 SP2 add-in is not supported on SharePoint 2010 products.
Download the Add-in
The SQL Server 2008 SP2 add-in for SharePoint 2007 products can be downloaded from the Microsoft download center. The add-in is packaged in the file rsSharePoint.msi. For more information, see Download SQL Server 2008 SP2.
This section lists the known issues you may encounter when integrating SQL Server 2008 R2 report servers with SharePoint 2007 products.
Reporting Services icons do not appear when integrated with SharePoint 2007
If you have integrated SharePoint 2007 sites that use Forms Based Authentication (FBA) with SQL Server 2008 R2 Reporting Services, you may not see the correct icons in the document library New menu. The Reporting Services options will be listed in the New menu but you will not see the correct icon next to the each of the options. The Reporting Services options will operate correctly, and their functionality is not affected by the missing icons.
To work around this issue:
Open SharePoint Central Administration.
Click Application Management.
Click Authentication Providers.
Select the appropriate Web application.
Click Yes to enable the client integration.
This issue applies to: Reporting Services Add-in for Microsoft SharePoint 2007, integrated with SQL Server 2008 R2 Reporting Services report server.
For FBA sites, the click-once implementations of Report Builder fail to start
When you attempt to start Report Builder as a click-once application from a SharePoint Web application configured for Forms Based authentication (FBA), you see an error message similar to the following:
- Cannot start Application error during download
The issue occurs when you attempt to start SQL Server Reporting Services Report Builder from a SharePoint site and all of the following conditions exist:
The SharePoint site you are attempting to start SQL Server Reporting Services Report Builder from, is configured for FBA.
The SharePoint server is using the SQL Server 2008 SP2 Reporting Services add-in for SharePoint 2007 products.
The SharePoint environment is integrated with a SQL Server 2008 R2 report server.
To work around this issue: Edit the web.config file for each site collection and add the following statement for enableReportBuilderAnonymousAccess to the “</configuration>” section:
<appSettings><add key="enableReportBuilderAnonymousAccess" value="true"/></appSettings>
This issue applies to: SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint 2007, integrated with SQL Server 2008 R2 Reporting Services report server.