STLukesTech
asked on
SQL reporting is Broke
Having an issue with my SQL 2012 The report server was working fine and now it appears to be non functional. I did do a restore of a Shelby database from one server to another, but just that Database. the following is the error I get:
The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help
Keyset does not exist (Exception from HRESULT: 0x80090016)
sqlerror.JPG
The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help
Keyset does not exist (Exception from HRESULT: 0x80090016)
sqlerror.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you delete all encrypted content (as it's suggesting), that just means that you'll have to re-enter any saved passwords that you have attached to those reports.