Hi ClaytonHoyt,
In your scenario, as you are coping the symmetric key from another report server, and symmetric key is not the same one that locks and unlocks encrypted data currently stored in the report server database. The copy that you restored is not valid, so the
report server cannot access the encrypted data currently stored in the report server database. For more information, please refer to this article:
Back Up and Restore Reporting Services Encryption Keys.
To fix the issue, please back up the ReportServer, ReportServerTempDB databases and configuration files for Reporting Services, then delete the encryption keys, the report server re-initializes itself automatically by adding a new symmetric key. Please refer
to this article:
Deleting Unusable Encrypted Content.
If you have any question, please feel free to ask.
Best regards,
Qiuyun Yu
Qiuyun Yu
TechNet Community Support
