







SQL Server Setup Help | |
How to: Troubleshoot Side-by-Side Installations of SQL Server 2000 and SQL Server 2005 Reporting Services | |
![]() |
![]() ![]() |
Installing SQL Server 2005 Components > Installing SQL Server Components How-to Topics > Reporting Services Installation How-to Topics > |
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.