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


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services
  • Microsoft SQL Server 2000 Reporting Services, Service Pack 1 (SP1)

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 -cLocation of your Rsreportserver.config file

Note This file is typically located in the C:\\Program files\Microsoft SQL Server\MSSQL\Reporting Services\Reportserver\Rsreportserver .config folder.
Modification Type:MinorLast Reviewed:10/25/2004
Keywords:kbtshoot kbprb KB887942 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.