SQL Server - Error - Asked By prathap chowdary on 23-Feb-12 12:33 AM


This is prathap.......
After configuration of Reporting service configuration manager.........when i am clicking report manager URL i got below error :

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0
Bad Data. (Exception from HRESULT: 0x80090005)
And all reporting service and analysis service all are running.

Please help me........

Chintan Vaghela replied to prathap chowdary on 23-Feb-12 12:36 AM


Applied as following way

Do you happen to have a backup of your encryption key?  If not, follow these steps:


Open Reporting Services Configuration Manager

Connect to your RS server

Select 'Encryption Keys' from the left pane

Press the 'Delete' button to get rid of your encrypted content


After doing this, you will need to re-set the connection strings and stored credentials on your reports.


Also, I'd be sure to make a backup of the encryption key afterwards.


If you do have a backup, press the 'Restore' button instead of the 'Delete' button.



Hope this is helpful !







prathap chowdary replied to Chintan Vaghela on 23-Feb-12 12:55 AM

It is working fine.
Chintan Vaghela replied to prathap chowdary on 23-Feb-12 01:03 AM
You welcome :)