Home > Report Server > Report Server Cannot Decrypt The Symmetric Key Used To Access

Report Server Cannot Decrypt The Symmetric Key Used To Access

Contents

Friday, May 20, 2011 10:42 AM Reply | Quote 0 Sign in to vote Hi All, Finally solved... Tuesday, July 03, 2012 2:16 PM Reply | Quote 0 Sign in to vote Thanks, from spain !! You may download attachments. Posted by William Lowers on 2/9/2010 at 6:04 AM I installed SSRS 2008 SP1 and have this issue. Check This Out

Posted by Teo Lachev on 2/22/2008 at 4:34 AM Lukasz,I'll keep an eye on this issue with CTP6 and re-open it if I can repro. Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Thanks! Posted by Ahsan Kabir on 8/10/2015 at 9:30 PM GO to >Reporting Services Configuration Manager >Press Connect > Go to Encryption Keys page >Press the 'Delete' button .Run Browser >Run as How to reply? https://connect.microsoft.com/SQLServer/feedback/details/322557/the-report-server-cannot-decrypt-the-symmetric-key

The Report Server Cannot Decrypt The Symmetric Key Sql 2008

This can be found in Start, Programs, Microsoft SQL Server 2005. How can I eliminate this problem? If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Tuesday, July 19, 2011 6:12 AM Reply | Quote 0 Sign in to vote Hi abs_dear, Please explain what you did to "re-set the connection strings and stored credentials on your

Menu Close Search SOLUTIONS Solutions Overview Unstructured Data Growth Multi-Vendor Hybrid Cloud Healthcare Government PRODUCTS Product Overview Backup and Recovery Business Continuity Storage Management Information Governance Products A-Z SERVICES Services Overview Thanks KumarKG, MCTS Monday, July 11, 2011 4:36 PM Reply | Quote 0 Sign in to vote Great..really helpful.... You must either restore a backup key or delete all encrypted content. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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

You must either restore a backup key or delete all encrypted content. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data. (Exception from HRESULT: 0x80090005) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] symKeyBlob) at Microsoft.ReportingServices.Library.ConnectionManager.b__2() The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account Comments (14) | Workarounds (0) | Attachments (0) Sign in to post a comment. No Yes Did this article save you the trouble of contacting technical support? https://support.microsoft.com/en-us/kb/955757 View my complete profile Private projects: www.MySkyMap.com My Android apps My WP7 apps My Windows Store apps Ads GDNExpress Followers Disclaimer All posts on this blog present my personal opinions and

Click Configure    Terms of use for this information are found in Legal Notices.

Related Articles Article Languages x Translated Content Please note that this document is a translation from Rsreportserverdisabled This can be beneficial to other community members reading the thread. 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". SQL Server Developer Center   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)

The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account

Can pls explain me the steps? It is possible that updates have been made to the original version after this document was translated and published. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 Hi Filip,Your instruction to execute "Delete Encrypted Content" in RSCM helped me in this error "The report server cannot decrypt the symmetric key...".Thank you.Waldek 15 March 2012 at 08:17 lokesh said... Delete Encrypted Content Reporting Services No Yes Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About

Posted by VenkatKokulla on 7/19/2011 at 12:05 AM Hello, Do you happen to have a backup of your encryption key? his comment is here On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? If SQL Server authentication is being used to retrieve data, select the “Credentials supplied by the user running the report" radio button.Additional CommentsIf the provided Resolution/Workaround does not resolve your issues, You cannot edit your own topics. Re-set The Connection Strings And Stored Credentials On Your Reports

This worked for me. Click on the Report Manager URL button on the left and then click on the URL displayed in the right pane. Thursday, May 10, 2012 8:16 AM Reply | Quote 0 Sign in to vote This helped me too. this contact form Update the Connection string field with the name of the server and the database that contains the data (‘master’ if you do not use a sql database)Example: Data Source=servername;Initial Catalog=DBnameAlso make

You cannot edit your own posts. The Report Server Cannot Decrypt The Symmetric Key 2012 While what he did with deleting encryption keys worked, it has drawbacks of losing that encryption information and if possible, you should use the steps below to revert back to the To help us diagnose, please attach the report server log files to the connect item.Thanks!

Posted by Edward Forgacs on 11/13/2008 at 4:29 AM Well, I have never *EVER* changed the account Reporting Services runs under, and I have had this bug probably 10 times, starting

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 ---   You cannot send emails. You may be trying to access this site from a secured browser on the server. You Must Either Restore A Backup Key Or Delete All Encrypted Content The Report Server uses an encryption key to save connection string information and saved user credentials.

Select ‘Encryption Keys’ from the left pane. Please enter a comment. References: https://msdn.microsoft.com/en-us/library/ms160340.aspx - Configure the Report Server Service Account (SSRS Configuration Manager) https://support.microsoft.com/en-us/kb/842421 - You receive an error message in the Reporting Services trace log when you restart the Report Server http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-used.html Thanks a lot from India.

Under the Encryption Keys section, click the delete button  3. The new account will be added to the RSExecRole. If you do have a backup, press the 'Restore' button instead of the 'Delete' button. Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. ---------------- Sunday, December 05, 2010 1:23 PM Reply

This helped me. It helped me as well... Monday, August 12, 2013 8:02 PM Reply | Quote 0 Sign in to vote \o/ thank you \o/ Wednesday, February 26, 2014 1:37 PM Reply | Quote 0 Sign in to You must either restore a backup key or delete all encrypted content.

Reporting services can lose knowledge of the encryption key and become unable to access the encrypted information. As I am now at that step. Open Reporting Services Configuration Tool ( Programs->Microsoft SQL Server 2008 R2 -> Configuration tools -> Reporting Services Configuration Manager) Go to Encryption Keys Click Delete.