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

Question

 

Hi every one,

 

I'm very new new at this.  I'm try to deploy a report model and got this message.  I have no idea what its going on about.

 

Can anyone help me?

 

Aku

 

------------------------------

System.Web.Services.Protocols.SoapException: 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) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
   at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
   at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
   at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
   at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
   at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)

------------------------------
BUTTONS:

OK
------------------------------

Answer 1

Hello,

 

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 helps.

 

Jarret

Answer 2

Hi Jarret,

 

thank you for your reply, I will try this tomorrow from the office as I don't have sql server on my home machine.  will let you know how I got on.

 

Aku

Answer 3

Hi Jarret,

 

thanks again.  this seems to have worked.  I don't understand it all properly yet but I was expecting a IE window to open with something to see and that didn't happend.  It did day in the bottom left conner that deployment secceded.  I am still going through the tutorial so when I get more confused I which I gurantee will happend, will post another message.

 

for now, thank you very much.

 

Aku

Answer 4

Thanks.  This solved the problem I was having.

Answer 5

Thanks. This helped me.

Answer 6

Helped me aswell. Cheers !

Answer 7

It is helpful to me.


Thanks.

Answer 8

HI Jarret,

I have same issue...
I deleted the encrypted keys.

earlier i havnt deployed any report to this reportserver.

but when m accessing the reportmanager and reportviewer still getting the same error message.

Wht should i do?

Waiting for reply...

Thanks & Regards,
Eshwar

Answer 9

Thank You this solved my problem.

Answer 10

Thanks. This helped me.

Answer 11

Thanx Ja.
it helped me
Regards
Sahu

www.appshark.com

My MSVBusinessCard Link

https://www.mcpvirtualbusinesscard.com/VBCServer/81f2e667-1d54-43b7-abc3-9fb4660a0d46/interactivecard

Answer 12

Thank UUUUUUUU :)...It helped me too

Answer 13

Thank You so much... It helped me as well...

Answer 14

It helped me. Thanks a bunch.

I do not understand seemingly as simple thing as this (once some one knows where to look for), why can not Microsoft provide proper documentation or links from the exception message box it showed us useless message as below...

-----------------

http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=10.50.1600.1

<form id="Form1" action="transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=10.50.1600.1" enctype="application/x-www-form-urlencoded" method="post">     Details ID: rsReportServerDisabled                                              Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings                                                  We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.   Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. </form>

----------------

Answer 15

Thanks lot..! it works

Answer 16

Thanks! It worked for me.

Answer 17

Thanks!

It worked for me!!!

Answer 18

Hi Jarret,

Thank you very much for the solution.

Suresh

Answer 19

Hi,

I am new to this.

Can you pls explain what do you mean by :

re-set the connection strings and stored credentials on your reports.

 

Can pls explain me the steps?

Answer 20

Hi All,

Finally solved...

Answer 21

Hi, thanks a lot!

I've tried to use instructions provided here: http://support.microsoft.com/kb/842421, but faced issues on the very first point, because system wouldn't export the key saying "Access denied".

Your sollution works perfectly, and is very easy to use.

Answer 22

Wow that helped me too.

Thanks

Kumar

---

KG, MCTS

Answer 23

Great..really helpful....

Answer 24

Hi abs_dear,

Please explain what you did to "re-set the connection strings and stored credentials on your reports"?

As I am now at that step.

Stewart

Answer 25

thanks

Answer 26

Hi Jarret,

Please explain what you did to "re-set the connection strings and stored credentials on your reports"?

I am not getting what to do in that step.

 

-Ayaz

Answer 27

Thanks., it helps!