SQL Server Reporting Services – rsReportServerDisabled error

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.

Technorati Tags:

2 thoughts on “SQL Server Reporting Services – rsReportServerDisabled error”

Leave a Reply to Anonymous Cancel reply

Your email address will not be published. Required fields are marked *