How to upgrade from Reporting Services Beta 2 to Reporting Services and preserve the existing data and the key (836064)

SUMMARY

Microsoft SQL Server 2000 Reporting Services Beta 2 expires after 180 days from the day of installation. To permanently obtain Reporting Services, you must upgrade from Reporting Services Beta 2 to the original released version of SQL Server 2000 Reporting Services. This step-by-step article describes how to upgrade from Reporting Services Beta 2 to Reporting Services.

If you used Reporting Services Beta 2 to develop reports and you want to use the existing report server data in Reporting Services, follow these steps:

1. Back up the symmetric encryption key and the Reporting Services database.
2. Remove Reporting Services Beta 2.
3. Install and configure Reporting Services.

Note Before you follow these steps, make sure that you have the setup files for Reporting Services.

INTRODUCTION

This step-by-step article describes how to upgrade from Reporting Services Beta 2 to Reporting Services while preserving the existing data and the symmetric encryption key on a report server that is running Reporting Services services (client components) and Reporting Services databases (server components).

When you upgrade from Reporting Services Beta 2 to Reporting Services, make sure that you meet the minimum requirements for the upgrade. For more information about the minimum requirements for the upgrade, see the Rssetup.chm file in Reporting Services. Additionally, complete the upgrade based on whether you must retain the existing data and key or discard them.

Note To determine the version of Reporting Services that you are running, type the following in the Address bar of Microsoft Internet Explorer: The version number of Reporting Services Beta 2 is 8.00.673.01.

back to the top

Back up the symmetric encryption key and the Reporting Services database

To use the existing report server data, back up the symmetric encryption key and the Reporting Services database that is used by Reporting Services Beta 2. To do so, follow these steps:

1. Log on to the computer as a local administrator.
2. Use the rskeymgmt command-line utility to back up the symmetric encryption key. To do so, run the following command at a command prompt:

   RSKeyMgmt.exe -e -f FileName  -p StrongPassword

   
   Note By default, the rskeymgmt command-line utility is located in the Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn folder. For more information about the rskeymgmt command-line utility, run the following command at a command prompt:

   RSKeyMgmt /?

3. Back up the existing ReportServer Reporting Services database and the ReportServerTempdb Reporting Services database. ReportServer and ReportServerTempdb are the default names of Reporting Services databases.

back to the top

Remove Reporting Services Beta 2

To remove Reporting Services Beta 2, use Add/Remove Programs in Control Panel.

Note In Add/Remove Programs, Reporting Services Beta 2 may be displayed as Microsoft SQL Server 2000 Reporting Services Evaluation Edition.

back to the top

Delete the COM+ packages and the folders that are related to Reporting Services

To delete the COM+ packages and the folders that are related to Reporting Services, follow these steps:

1. Delete all the COM+ packages that are related to Reporting Services. To do so, follow these steps:
   1. Click Start, point to Programs, point to Administrative Tools, and then click Component Services.
   2. In the left pane of the Component Services window, expand the Component Services folder.
   3. Expand the Computers folder.
   4. Expand the My Computer folder, and then expand the COM+ Applications folder.
   5. In the COM+ Applications folder, right-click the IIS-{Default Web Site//Root/ReportServer} package, and then click Properties.
   6. In the IIS-{Default Web Site//Root/ReportServer} Properties dialog box, click the Advanced tab, and then under Permissions, click to clear the Disable deletion check box.
   7. Click OK.
   8. Click Yes.
   9. Repeat steps e through h for the IIS-{Default Web Site//Root/Reports} package.
   10. In the Component Services window, right-click IIS-{Default Web Site//Root/ReportServer}, and then click Delete.
   11. In the Component Services window, right-click IIS-{Default Web Site//Root/Reports}, and then click Delete.
2. Delete the Reports virtual directory and the ReportServer virtual directory from your computer. To do so, follow these steps:
   1. Click Start, and then click Run.
   2. In the Open box, type inetmgr, and then click OK.
   3. In the left pane, expand ComputerName, and then expand Default Web Site.
   4. Under Default Web Site, locate and then delete the Reports virtual folder and the ReportServer virtual folder.
3. Delete the folder that contains Reporting Services Beta 2. By default, Reporting Services is installed in the Installation drive:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services folder.
4. Restart your computer.

back to the top

Install Reporting Services

Before you install Reporting Services, see the Readme file (Readme_en.htm) and the Rssetup.chm file for Reporting Services. These files document the installation requirements and possible installation issues, configuration issues, and other known issues that are related to Reporting Services.

To install Reporting Services, follow these steps:

1. Log on to the computer as a local administrator.
2. Disable any antivirus software that is running on your computer.
3. In the Reporting Services installation folder, locate the Setup.exe file, and then double-click Setup.exe to start the installation of Reporting Services.
4. Follow the steps in the installation wizard until you reach the Report Server Database page.
5. On the Report Server Database page, type newreportserver in the Name box.
   
   Note Make sure that the database name that you use is different from the name that you specified when you installed Reporting Services Beta 2. By default, ReportServer is specified as the database name for Reporting Services Beta 2.
6. Complete the steps in the installation wizard.

back to the top

Upgrade the Reporting Services databases to Reporting Services

To upgrade the ReportServer database and the ReportServerTempdb database to Reporting Services, follow these steps:

1. Run theUpgradebeta2catalog.sql script file in the context of the ReportServer database. To do so, follow these steps:
   1. Start SQL Query Analyzer.
   2. In SQL Query Analyzer, click the ReportServer database that was installed with Reporting Services Beta 2.
   3. On the File menu, click Open.
   4. In the Open Query File dialog box, locate the following SQL script file, and then click Open:
      
      Installation drive:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\upgradebeta2catalog.sql
   5. On the Query menu, click Execute.
2. Run the Upgradebeta2catalogtempdb.sql script file in the context of the ReportServerTempdb database. To do so, follow these steps:
   1. In SQL Query Analyzer, click the ReportServerTempdb database that was installed with Reporting Services Beta 2.
   2. On the File menu, click Open.
   3. In the Open Query File dialog box, locate the following SQL script file, and then click Open:
      
      Installation drive:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\upgradebeta2catalogtempdb.sql
   4. On the Query menu, click Execute.
3. Run the UpgradeStoredprocs.sql file in the context of the ReportServer database. To do so, follow these steps:
   1. In SQL Query Analyzer, click the ReportServer database that was installed with Reporting Services Beta 2.
   2. On the File menu, click Open.
   3. In the Open Query File dialog box, locate the following SQL script file, and then click Open:
      
      Installation drive:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\UpgradeStoredprocs.sql
   4. On the Query menu, click Execute.

back to the top

Configure the report server instance

To configure the report server instance to use the upgraded ReportServer database and the upgraded symmetric encryption key, follow these steps:

1. Use the rsconfig.exe command-line utility to configure the report server instance to use the upgraded ReportServer database. To do so, run the following command at a command prompt:

   RSConfig -s serverName -d reportDatabaseName -a Sql|Windows -u userAccount -p userAccountPassword

   Note For more information about the rsconfig command-line utility, run the following command at a command prompt:

   RSConfig /?

2. On the report server instance, use the rskeymgmt command-line utility to apply the keys that you previously saved. To do so, run the following command at a command prompt:

   RSKeyMgmt -a -f FileName -p strongPassword

   Note Replace FileName and strongPassword with the file name and the password that you used to back up the symmetric encryption key in the "Back up the symmetric encryption key and the Reporting Services database" section in this article.
3. Restart your computer.

back to the top