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 SQL Server Reporting Service Reports, I got the below error:

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

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


Cause 

The SSRS encryption keys are not configured properly.


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

Open Reporting Service Configuration Manager

  • Select ‘Encryption Keys’ from the left pane.

Encryption Keys In SSRS

  • If you have a backup key with extension “.snk” and Password, Click on the ‘Restore’ button.

Restore Encryption Keys in SSRS

  • If you do not have Encryption Keys backup key > Click on ‘Delete’ button.

SSRSCM-Encryption KeysDelete

  • Wait a moment until getting that result.

Delete Encrypt keys in SSRS

  • Reconfigure the data sources in your reports by using Report Manager.

Note: No need to do this step if you already have backup Key and restored it.

Manage Data source in SSRS

SSRSRM-ManageDS

  • Optionally, Restart IIS (Open CMD –> IISRESET).

Applies To

SQL Server Reporting Service

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 )

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