Microsoft Download Center Archive

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

  • Published:
  • Version: 9.00.3294
  • Category: Application
  • Language: English

The Microsoft SQL Server 2005 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.

  • Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies (Reporting Services Add-in) allows you to take advantage of SQL Server 2005 Service Pack 2 (SP2) report processing and management capabilities within Windows SharePoint Services 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.

    The Reporting Services Add-in works together with SP2, which is required on the report server. SP2 provides the following functionality for a report server that is configured for SharePoint integrated mode:

    • Synchronization from SharePoint content database to the report server database.
    • A custom security extension that uses SharePoint permissions to control access to report server operations.
    • A new 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 new SOAP endpoint for managing report server content in SharePoint integrated mode.

    Warning: Requires Microsoft Security Bulletin MS08-052
    To use this version of the Reporting Services Add-in, the SQL Server Reporting Services server deployment used in conjunction with the Reporting Services Add-in must be patched with the updates listed under Microsoft SQL Server in Microsoft Security Bulletin MS08-052

    Warning: No automatic upgrade support
    Pre-release (CTP) versions of the Reporting Services Add-in cannot be upgraded to this released version.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
readme_rsaddin.htm13cc33cab62410dbcd1bda40fd5da4478aeefe3316 KB
SharePointRS.msi39bca08500cae8a8e16b32e2434873ef195b1c9b35.67 MB
SharePointRS_x64.msi1b3479b96bf6974e5b41c1c2619216395fc0d54f35.76 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows Server 2003 Service Pack 1

    • 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.
    • Microsoft Windows Server 2003 with the latest service packs (x86 only), configured to run as an Application Server with ASP.NET 2.0 enabled.
    • SQL Server 2005 SP2 Reporting Services. (Supported SQL Server editions include Standard, Evaluation, Developer, and Enterprise. Server integration is not supported on the Workgroup Edition of Reporting Services or SQL Server 2005 Express with Advanced Services.)
    • SQL Server 2005 SP2 Reporting Services must be patched with updates listed under Microsoft SQL Server in Microsoft Security Bulletin MS08-052
    • 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.

Installation 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 Reporting Services, apply SQL Server 2005 Service Pack 2, and apply updates listed under Microsoft SQL Server in Microsoft Security Bulletin MS08-052.

      Step 3: Configure Reporting Services.

      Step 4: Download the Reporting Services Add-in by clicking the SharePointRS.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.

Related Resources