SQL – Reporting Services Error – Keyset does not exist

Recently while working with an third party vendor we came across and issue where the SQL Reporting Services displayed the error below when attempting to browse to the ReportServer:

The report server was unable to validate the integrity of the encrypted data in the database. (rsCannotValidateEncryptedData) Keyset does not exist (Exception from HRESULT: 0x80090016)

2018-11-27_11-33-50

I first attempted to delete the encryption keys from the Reporting Services Configuration Manager but I was unable to do so. This wasn’t really ideal but since the server was not 100% in production now would be the time to take such a measure.

Below was the error:

2018-11-26_11-50-06

I then recalled that when I initially set up SSRS I had used a different service account for the Reporting Service. It was changed at the vendor’s request.  Once I had changed back the login account to the previous setup account the error was resolved.

Moving forward though I believe if I where to use a new account then the encryption keys would need to be deleted and SSRS would need to be reconfigured with that new account.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s