Error rsReportServerDisabled: 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.

Published: 2007-07-23

 

Last Updated: 2010-07-26

Applies To

 

Symptoms

When attempting to run a report using Reporting Services SE

-or-

When attempting to access the Reporting Services Report Server via your web browser

 

You receive the following error:

 

 

 

Cause

The Microsoft Reporting Services 2000 Report Server service uses the symmetric key to access the encrypted data in a report server database. This symmetric key is encrypted by using an asymmetric public key that corresponds to the computer and the user account that is used to run the Report Server service. When you change the user account that is used to run the Report Server service, the report server cannot use the asymmetric public key to decrypt the symmetric key. Therefore, the Report Server service cannot use the symmetric key to access the data from the report server database.

 

Refer to Microsoft Knowledge Base article 842421 for more information.

 

 

Resolution

On the Guard1 Plus SE Server PC:

  1. Open a Command Window.
  2. Navigate to C:\Program Files\Guard1 Plus SE Server.
  3. Type G1RSCfg 603;Supervisor User;Supervisor Password;Data Source Name then press Enter.
    • Where:
      • Supervisor User = the login for an Application user that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor login
      • Data Source Name = the name of the Master data source (can be obtained by running G1Cfg 00
  4. Click Yes to confirm.
  5. Click OK.
  6. Repeat Steps 3-5 two more times.
  7. Exit the Command Window.
  8. Open My Computer/Windows Explorer and navigate to C:\Program Files\Guard1 Plus SE Server.
  9. Delete the file RS.ini.
  10. On the SQL Server PC, open a Command Window.
  11. Navigate to C:\Program Files\Microsoft SQL Server\80\Tools\Binn.
  12. Type rsactivate -r -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
  13. Press Enter.
  14. Close the Command Window.
  15. Re-run the G1RSSetupWizard to reconfigure Guard1 Plus SE Reporting Services.
  16. Uninstall and reinstall the Reporting Services Client on each workstation.

 

Attempt to perform the action that triggered the error.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.