A while ago I had to test a report created with SQL Server 2000 Reporting Services. After installing Reporting Services and uploading the reports, went I attempted to access them I was shown the following error message.
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
A little bit scary as I had no backup! After a bit of searching, I worked out I had to execute this command:
C:Program FilesMicrosoft SQL Server80ToolsBinn> rsactivate -r -c”C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerRSReportServer.config”
After which, everything worked just fine.
Thanks Buddy.. saved my life.
Excelent, thanks