The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database
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------------------------------
May 25th, 2007 6:17pm
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
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2007 8:28pm
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
May 30th, 2007 12:09pm
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
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2007 12:31pm
Thanks. This solved the problem I was having.
September 11th, 2009 9:41pm
Thanks. This helped me.
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2009 5:06pm
Helped me aswell. Cheers !
November 2nd, 2009 1:07pm
It is helpful to me. Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2009 6:40am
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
January 7th, 2010 3:53pm
Thank You this solved my problem.
Free Windows Admin Tool Kit Click here and download it now
January 11th, 2010 11:32pm
Thanx Ja.it helped meRegardsSahu
www.appshark.com
My MSVBusinessCard Link
https://www.mcpvirtualbusinesscard.com/VBCServer/81f2e667-1d54-43b7-abc3-9fb4660a0d46/interactivecard
February 26th, 2010 8:20am
Thank UUUUUUUU :)...It helped me too
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2010 9:49pm
Thank You so much... It helped me as well...
April 9th, 2010 5:26pm
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>
----------------
Free Windows Admin Tool Kit Click here and download it now
December 5th, 2010 4:23pm
Thanks lot..! it works
December 15th, 2010 9:23am
Thanks! It worked for me.
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2010 12:08am
Thanks!
It worked for me!!!
December 23rd, 2010 12:08am
Hi Jarret,
Thank you very much for the solution.
Suresh
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 6:38pm
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?
May 20th, 2011 1:42pm
Hi All,
Finally solved...
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 9:05am
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.
May 25th, 2011 2:23pm
Wow that helped me too.
Thanks
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2011 7:36pm
Great..really helpful....
July 19th, 2011 9:12am
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
Free Windows Admin Tool Kit Click here and download it now
August 15th, 2011 9:13am
thanks
August 30th, 2011 4:00pm
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
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2011 5:40pm
Thanks., it helps!
May 10th, 2012 4:21am