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
Under <drive>:\Documents and Settings\<machine_name>\ASPNET\Application Data\Microsoft\Crypto\RSA\, search for a file named '1aedd7b5699f3d6a88e354100b596aae*'.
Delete the file.
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
Tasks
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