Export (0) Print
Expand All
1 out of 9 rated this helpful - Rate this topic

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

SQL Server 2005

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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.