You are here:Home » tsql » The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database in SQL Server

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


I ran into one issue while configuration of the reporting service in sql server and got the error to load the reports,

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError)

Finally i got the solution to resolve this issue as following,

Go to the Report Service Configuration Option and delete the encrypted content. Please take a backup of key before deleting.