Restore ReportServer Database
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 thehttp://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.
