Sunday, March 01, 2009

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

Ooops what is this error!!!

when i was configuring MS SQL Reporting Services 2005 on the way to installing Microsoft CRM Server i had to encounter for the error:

"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)"

the solution for that error is to delete the Encryption Key in the Reporting Services Configuration.

the step is :

Start => Programs => Microsoft SQL Server2005 => Configuration Tools => Reporting Services Configuration => Encryption Keys.

SQLReporting

2 comments:

oren said...

I think the step should not just stop until delete Encryption Keys, but also then we should check all data source in report server that we used, then fill in the connection string (again). because we will lost all connection string.
Except we ever backup the encryption key, we then only need to restore it.

Cuong Luc said...

Your post really helps me. I sorted it out with your solution.