SSRS Error – The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

When I tried to deploy SSRS reports ,I got the following error:

The report server cannot decrypt the symmetric key used to access sensitive
 or encrypted data in a report server database

thereportservercannotdecrypt

Cause :

The SSRS encryption keys have not been configured properly.

Solution:

It was the first time that I saw a clear error message that described What I should do to solve this error ?! However, I will explain How to solve it in details!

  • Open Reporting Service Configuration Manager > Connect to SSRS Server Instance.

SSRSCM-ConnectToServer

  • Select ‘Encryption Keys’ from the left pane.

SSRSCM-Encryption Keys

  • If you have a backup key with extension .snk and Password, Press the ‘Restore’ button.

SSRSCM-Encryption KeysRestore

  • If you do not have a backup key Press ‘Delete’ button.

SSRSCM-Encryption KeysDelete

  • Wait until get this result.

DeleteEncryptkeys

  • Reconfigure the data sources in your reports by using Report Manager. (No need if you already have a back up Key).

SSRSRM-ManageDS

  • Restart IIS (Open CMD –> IISRESET).

The issue should now been solved.

Enjoy 🙂

Advertisements

2 thoughts on “SSRS Error – The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s