Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies, April 2009

Brief Description
The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

On This Page

Quick Details
Version:10.00.2531.00
Date Published:4/7/2009
Language:English
Download Size:14 KB - 197.0 MB*
*Download size depends on selected download components.
Change Language:
  

Overview

Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007. The download provides the following functionality:

  • A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print, and zoom.
  • Web application pages so that you can create subscriptions and schedules, and manage reports, models, and data sources.
  • Support for using standard Windows SharePoint Services features including document management, collaboration, security, and deployment with report server content types.

This Reporting Services Add-in works together with SQL Server 2008 Reporting Services, which is required for the report server instance. SQL Server 2008 Reporting Services provides the following functionality for a report server that runs in SharePoint integrated mode:

  • Synchronization from the SharePoint content database to the report server database.
  • A custom security extension that uses SharePoint permissions to control access to report server operations.
  • A delivery extension that you can use in subscriptions to deliver reports to SharePoint libraries.
  • A revised Reporting Services Configuration tool that you can use to configure a report server for SharePoint integrated operations.
  • A SOAP endpoint for managing report server content in SharePoint integrated mode.
  • Support for new data-driven subscriptions and URL parameters.
  • In-place upgrade of the Reporting Services Add-in.

Report Builder 2.0 ClickOnce update for the RS SharePoint add-in
Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services. This download provides a ClickOnce update for the RS SharePoint add-in.

Warning:
The Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 Reporting Services (SSRS) instance. This add-in is not supported with earlier versions of SSRS.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 7; Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP Service Pack 3
  • The Microsoft .NET Framework 3.0.
  • 40 MB of available hard disk space.
  • 2 gigabytes of RAM.

The computer must meet the following software requirements:
  • Microsoft Office SharePoint Server 2007 or Windows SharePoint Services 2007 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 Reporting Services. (Supported SQL Server editions include Standard, Evaluation, Developer, and Enterprise.)
  • Windows SharePoint Services 3.0 or Office SharePoint Server 2007. The Reporting Services Add-in is not supported on earlier versions of Windows SharePoint Services.
  • 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.

 Top of page

Instructions

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 Reporting Services Add-in.

    Step 1: Install a SharePoint technology instance.

    Step 2: Install SQL Server 2008 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.

 Top of page

Additional Information


 Top of page

Files in This Download

The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
File Name:File Size

RB2ClickOnce.msi

117.6 MB

Readme_rsaddin.htm

47 KB

Readme_rsclickonceaddin.htm

14 KB

rsSharePoint.msi

39.5 MB

rsSharePoint_x64.msi

39.8 MB

 Top of page

 Top of page

 Top of page

 Top of page

© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement