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

The Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint. Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site.

This download provides a Report Viewer Web part, Web application pages, and supports SharePoint 2010. New capabilities delivered include:

• Multizone support. Use the alternate access mapping functionality in your SharePoint environment to access report server items from one or more SharePoint zones (default, internet, intranet, extranet, or custom). This is useful when you have a SharePoint environment that can be accessed by users from multiple zones


• SharePoint list support. Access SharePoint lists as data sources for building reports in Report Builder


• Ribbon user experience. Group reports in a more logical manner through the extension of the SharePoint ribbon, making content much easier to find

Distribution of RSSharePoint.msi: Use of RSSharePoint.msi is subject to the license terms included in the “RSSharePoint” download file. Those terms do not include rights to distribute RSSharePoint.msi. If you wish to distribute RSSharePoint.msi with your programs, you must:

• Download the above “RSSharePoint.msi - Supplemental Redist License.rtf” and review the enclosed Microsoft Software Supplemental License Terms for Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010 with additional use terms for Distributable Code (Supplemental Terms)
• Print and retain a copy of the Supplemental Terms for your records
• By Downloading and Printing the Supplemental Terms located in the RSSharePoint.msi - Supplemental Redist License.rtf, you (i) acknowledge you have read the Supplemental Terms, and (ii) agree to the terms as stated in the Supplemental Terms. If you do not accept them, you do not have any rights under these Supplemental Terms.

Supported Operating Systems

Windows 7, Windows Server 2003, Windows Server 2008 R2, Windows Vista, Windows XP

• 25 MB of available hard disk space is needed for the Add-in.
• Review the Windows SharePoint Services or Office SharePoint Services 2010 documentation for relevant system requirements.

The computer must meet the following software requirements:

• Microsoft Office SharePoint Server 2010 or Windows SharePoint Services 2010 with .NET Programmability Support.
• If running on Microsoft Windows Server 2003, have the latest service packs (x86 only) installed, and configure the server to run as an Application Server with ASP.NET 2.0 enabled.
• SQL Server 2008 R2 Reporting Services (Supported SQL Server editions include Standard, Evaluation, Developer, and Enterprise.)
• The Web sites cannot be enabled for Anonymous access.
• Microsoft Internet Explorer 6.0 with SP2 or later. Microsoft Internet Explorer 7.0 is strongly recommended.

You can install and configure the servers in any order, but integrated operations will not be available until the configuration steps are complete for both servers. For detailed information on the installation steps, see the Readme for the existing Reporting Services Add-in.

Step 1: Install a SharePoint technology instance.

Step 2: Install SQL Server 2008 R2 Reporting Services and specify that the report server use SharePoint Integrated mode.

Step 3: Configure Reporting Services.

Step 4: Download the Reporting Services Add-in by clicking the rsSharePoint.msi link later on this page. To start the installation immediately, click Run. To install at a later time, click Save.

Step 5: Install the Reporting Services Add-in and configure the report server on the SharePoint technology instance.

Step 6: Set permissions and add Reporting Services content types.

Step 7: Verify the installation.

• If you have questions about the Reporting Services Add-in, visit the SQL Server Reporting Services Forum on MSDN.



• Help improve the Reporting Services Add-in by submitting bugs to the Connect Feedback Center.