Accidentally the key tables were deleted from our ReportServer SQL Database.
We tried copying the tables over from the ReportServer TempDB, but this then broke the encryption key (which we did not have access to the backup of).
We then ran rsconfig -c to restructure the db connection and generate a new key. But unfortunately our old data was encrypted by the old key.
We are also getting the following error on the http://localhost/Reports page:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.6.51'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
The recomended fix for this error is to reinstall Reporting Services from scratch.
We were hoping that there maybe another way around this, preferably away we can just restore from he TempDB.
Thanks for your attention.
The tempdb is not a copy of the main report server database. It contains a different set of data. The main database stores report defintitions, data sources, security settings, schedules, etc. The tempdb stores dynamic data , such as report snapshot that are current being viewed. You can't restore one from the other.
If you don't have a backup of the encryption key, you will need to delete all encrypted content in the database via the config tool. If you have lost your entire report server database (which sounds like it is the case) and don't have a backup, you will need to rebuild it from scratch.
