SQL Server 2000 Reporting Services Service Pack 1

Select Language:
Service Pack 1 (SP1) for Microsoft® SQL Server™ 2000 Reporting Services includes bug fixes, performance enhancements, and some functional enhancements.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:



    Date Published:


    File Size:

    18.2 MB

    53 KB

      SP1 includes a variety of improvements to the initial product release. Documentation for this release is provided in the SP1readme_lang.htm file which can be downloaded below or found in the Reporting Services installation directory after Setup is complete.

      Key Functional Enhancements

      • Excel rendering extension has been improved and now supports viewing in Excel 97 and 2000.

      • PDF rendering extension is more robust and has better performance.

      • Chart control provides more control over display styles.

      • References to external URLs (images and resources) from within a report are now supported.

      • Data caching behavior for report preview is now supported.

      • Newline in expressions is now supported.

      • The style of the HTML Viewer toolbar can now be modified through a style sheet.

      • New URL parameters offer more options for customizing report presentation at run time

      • Report Manager proxy persists authentication cookies so that they can be used by custom security extensions.

      • Hidden parameters are now supported.

      • Temporary snapshots can be compressed as well as stored on the file system.

      • Integrated security support for accessing report data sources can be disabled.

  • Supported Operating System

    Windows 2000 Advanced Server, Windows 2000 Professional Edition , Windows 2000 Server, Windows Server 2003, Windows XP Professional Edition

      • SP1 Setup upgrades all four editions of Reporting Services (Enterprise, Developer, Standard, and Evaluation). It also upgrades all installation configurations (client-only, server-only, and client-server).

      • SP1 requires 40 MB of free disk space to install.
    • Important: Read this before installing SP1.

      • Installing SP1 modifies your Report Server databases. The upgraded database will be incompatible with pre-SP1 versions of Reporting Services. Back up the ReportServer and ReportServerTempDB databases using the SQL Server management tools. These backups will therefore be necessary if you decide to reinstall SQL Server 2000 Reporting Services without SP1.
      • There is no uninstall feature for Service Pack 1. To revert to the version that you were running before installing SP1, you must uninstall Reporting Services and then reinstall it from the original media.
      • Back up a copy of the database encryption keys. For more information, see Managing Encryption Keys.

      Reporting Services SP1 is an update that you apply to an existing installation of Reporting Services. You can run SP1 by running the self-extracting executable or by extracting the files using the command line options and running SP1Setup.exe. Setup upgrades only the components that are currently installed. If you subsequently install additional components, you must rerun SP1 Setup to update those components.

      Click the SQL2KRSSP1-lang.EXE download link at the bottom this page to start the download, and do one of the following:

      • To start the installation immediately, click Open or Run this program from its current location.
      • To copy the download to your computer for installation at a later time or installation using the command line options, click Save or Save this program to disk.
    • This service pack is independent of the service packs for SQL Server 2000. Microsoft recommends that you apply the latest SQL Server 2000 Service Pack before installing Reporting Services SP1.