How to: Troubleshoot Side-by-Side Installations of SQL Server 2000 and SQL Server 2005 Reporting Services

New: 5 December 2005

An installation of SQL Server 2000 Reporting Services that runs on Internet Information Services (IIS) 5.0 or IIS 5.0 isolation mode might stop running if you perform a side-by-side installation of SQL Server 2005 Reporting Services, or if you install the Microsoft .NET Framework version 2.0 or register ASP.NET 2.0 on the host computer. Errors that occur vary by operating system.

Operating system Error message

Microsoft Windows XP

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service.

Other Windows servers

Key not valid for use in specified state.

After you install SQL Server 2005 Reporting Services, perform the following steps to update your SQL Server 2000 version of Reporting Services installation.

To update a SQL Server 2000 Reporting Services installation

  1. Under <drive>:\Documents and Settings\<machine_name>\ASPNET\Application Data\Microsoft\Crypto\RSA\, search for a file named '1aedd7b5699f3d6a88e354100b596aae*'.

  2. Delete the file.

  3. Run RSActivate –r –c <rsreportserver.config file>, specifying the fully qualified path of the RSReportServer.config file of the SQL Server 2000 Reporting Services installation. If the path includes spaces, be sure to enclose the entire path in quotation marks.

See Also


How to: Install Reporting Services Side-by-Side with an Earlier Version
How to: Troubleshoot a Reporting Services Installation Problem

Other Resources

Reporting Services Installation How-to Topics

Help and Information

Getting SQL Server 2005 Assistance