Microsoft KB Archive/887942

= You receive an error message when you try to access Report Manager in SQL Server 2000 Reporting Services =

Article ID: 887942

Article Last Modified on 10/25/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services
 * Microsoft SQL Server 2000 Reporting Services Service Pack 1

-



SYMPTOMS
When you try to access the Report Manager component in Microsoft SQL Server 2000 Reporting Services, you may receive the following error message:

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. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data.”



CAUSE
This problem may occur if you reset the Microsoft ASP.NET account. The ASP.NET account can be reset in the following ways:
 * You install the .NET Framework 1.1 Service Pack 1 (SP1) Windows update.
 * You run the ASP.NET IIS Registration tool (Aspnet_regiis.exe) by using the –i option.
 * You install a .NET Framework hotfix.



RESOLUTION
To resolve this problem, re-activate the report server. To do this, run the following command in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder:

rsactivate –r –c

Note This file is typically located in the C:\\Program files\Microsoft SQL Server\MSSQL\Reporting Services\Reportserver\Rsreportserver .config folder.

Keywords: kbtshoot kbprb KB887942

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.