SQL Server 2000 Reporting Services Service Pack 1

Brief Description

Service Pack 1 (SP1) for Microsoft® SQL Server™ 2000 Reporting Services includes bug fixes, performance enhancements, and some functional enhancements.

Overview

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.

To view a list of the bug fixes in SP1, see Microsoft Knowledge Base article 839796.
Late-breaking information that was not available in time to be included in this readme file will be published on the Microsoft Product Support Services Web site in Microsoft Knowledge Base article 843369.
To get the complete set of installation instructions, see Microsoft Knowledge Base article 842857.

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.

Top of page

System Requirements

Supported Operating Systems: 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.

Top of page

Instructions

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.

Top of page

Additional Information

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.

Top of page