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

SQL Server 2000 Reporting Services Service Pack 2 (SP2)

Brief Description
Service Pack 2 (SP2) for Microsoft SQL Server 2000 Reporting Services includes bug fixes and some functional enhancements.

On This Page

Quick Details
Version:8.00.1038
Date Published:4/22/2005
Language:English
Download Size:74 KB - 21.6 MB*
*Download size depends on selected download components.

Change Language:
  

Overview

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


Note: Service Pack 2 will require a reboot after installation. For more information, see Knowledge Base article 889641.

Key Functional Enhancements

  • SharePoint Web parts enable you to explore and view reports located on a report server by using Microsoft Windows SharePoint Services or SharePoint Portal Server.
  • Reports can now be printed directly from within Internet Explorer. A Microsoft ActiveX control is provided to support a rich client-side printing experience including full page preview.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Advanced Server; Windows 2000 Server; Windows 2000 Service Pack 2; Windows Server 2003; Windows XP Professional Edition
  • SP2 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).

  • SP2 can be applied to an existing installation of Reporting Services or an existing installation of Reporting Services with Service Pack 1.
  • SP2 requires 40 MB of free disk space to install.

 Top of page

Instructions

Important: Read this before installing SP2.

  • Installing SP2 modifies your Report Server databases. The upgraded database will not be compatible with pre-SP2 versions of Reporting Services. Back up the ReportServer and ReportServerTempDB databases using the SQL Server management tools. These backups will be necessary if you decide to reinstall SQL Server 2000 Reporting Services without SP2.

  • There is no uninstall feature for Service Pack 2. To revert to the version that you were running before installing SP2, you must uninstall Reporting Services and then reinstall it from the original media.

  • Back up a copy of the database encryption key. For more information, see Managing Encryption Keys.

Click the SQL2KRSSP2-lang.EXE download link at the bottom of 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 Service Pack before installing Reporting Services SP2.

 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

sp2Readme_EN.htm

74 KB

SQL2KRSSP2-ENG.EXE

21.5 MB

 Top of page

 Top of page

 Top of page


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