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
STLukesTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Did someone change the windows password for the login used on the service?

You can use the Change Encryption Key or Delete existing encrypted content via the Reporting Services Configuration Manager -> Encryption Keys node.

NOTE: Deleting encrypted content will remove the link between the data sources and data sets on the reports (and you may also loose subscription data). That will need to be recreated.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan McCauleyData and Analytics ManagerCommented:
If you restore the database and you haven't loaded a backup of the encryption key (through the front end), it won't be able to decrypt the secured content in the database. It will still run reports without a problem, but the encrypted content includes things like logins and passwords.

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.