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

Report Server Cannot Decrypt The Symmetric Key Used

Contents

You cannot post or upload images. 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... Not the answer you're looking for? Where can I read CS papers? check my blog

Wednesday, May 25, 2011 11:23 AM Reply | Quote 0 Sign in to vote Wow that helped me too. You cannot edit other topics. US Election results 2016: What went wrong with prediction models? You cannot delete your own events. 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

Is there still a way to prevent Trump from becoming president? You cannot send private messages. share|improve this answer answered Mar 10 '15 at 18:09 Tom 321110 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data

If you have a backup key with extension .snk and Password, Press the ‘Restore’ button. Build me a brick wall! You cannot post HTML code. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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

Deleting the encryption keys was not an option and I knew the password used to create the encryption key, so I took a backup of the key from the working server The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account Refreshed the page and the error went away. Are there still systems around with a /bin/sh binary? 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 cannot delete other events. Rsreportserverdisabled You cannot rate topics. For more information, see Administer a Report Server Database (SSRS Native Mode) in SQL Server Books Online. You cannot upload attachments.

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

By Reseting it will it delete the data source and I have create new one. https://blog.devoworx.net/2014/11/30/ssrs-error-the-report-server-cannot-decrypt-the-symmetric-key-used-to-access-sensitive-or-encrypted-data-in-a-report-server-database/ Give us your details to arrange a call-back. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 You cannot edit your own topics. Delete Encrypted Content Reporting Services No Yes How can we make this article more helpful?

Submit Posted by Banketeshvar Narayan on 1/31/2016 at 6:40 AM I used the suggestion of @Ahsan "GO to >Reporting Services Configuration Manager >Press Connect > Go to Encryption Keys page >Press click site 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() You must either restore a backup key or delete all encrypted content. If like in my scenario, you happen to know what the previous service account user was, the fix is to change the SQL Server Report Service account user back to the Re-set The Connection Strings And Stored Credentials On Your Reports

Polyglot Anagrams Robbers' Thread more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Stewart Monday, August 15, 2011 6:13 AM Reply | Quote 0 Sign in to vote thanks Tuesday, August 30, 2011 1:00 PM Reply | Quote 0 Sign in to vote Hi This worked for me. news You must either restore a backup key or delete all encrypted content and then restart the service.

Your sollution works perfectly, and is very easy to use. The Report Server Cannot Decrypt The Symmetric Key 2012 And it seems the only way to fix it is to delete the Encryption keys. https://technet.microsoft.com/en-us/library/hh699754.aspx The key trigger here that is likely the root cause seen in the Haasan's question was the changing of the SQL Server Reporting Services service account without backing up the

Thank you Thursday, May 15, 2014 4:44 PM Reply | Quote 0 Sign in to vote Hi Guys!

But by doing so, I have to reset all connection strings and db credentials for all of my data sources.My question is :Since I have more than 300 reports and 5 The database login for the old account will not be removed automatically. The report is showing in WEb browser and SCCM Report now... You Must Either Restore A Backup Key Or Delete All Encrypted Content Comments (14) | Workarounds (0) | Attachments (0) Sign in to post 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 A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data It helped me as well... More about the author You cannot delete other posts.

Post navigation ← Previous Next → SSRS Error - The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report serverdatabase Posted on November To help us diagnose, please attach the report server log files to the connect item.Thanks! Veritas does not guarantee the accuracy regarding the completeness of the translation. Hope this helps.Venkat Posted by lukek on 11/10/2010 at 7:32 AM happens regulalry for me too - the server isnt used much - reapplying the key (even after regenerating it) fixes

Drawing a torso with a head (using \draw) Can floyd like bridge really make guitar out of tune when not blocked but not used How much time would it take for You may read topics. Tuesday, November 17, 2009 3:40 AM Reply | Quote 0 Sign in to vote HI Jarret,I have same issue...I deleted the encrypted keys.earlier i havnt deployed any report to this reportserver.but Isnt it?Also can I get the connection string of all my data sources from the report server DB?Any help will be highly appreciated.Thanks Post #1585804 Jack Corbett Jack Corbett Posted Wednesday,

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() Be sure to correct all data sources actively being used.To resolve the issue, do the following: Start the Reporting Services Configuration Manager by going to Start >Programs > Microsoft SQL Server Attachment Products Subscribe to Article Search Survey Did this article answer your question or resolve your issue? Open Reporting Services Configuration Tool ( Programs->Microsoft SQL Server 2008 R2 -> Configuration tools -> Reporting Services Configuration Manager) Go to Encryption Keys Click Delete.

Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Thanks! The report server cannot decrypt the symmetric key - by Teo Lachev Status : Closed as Not Reproducible Not Reproducible The product team could not reproduce this item with the When you change the user account that is used to run the Report Server service, the report server cannot use the asymmetric public key to decrypt the symmetric key. Posted by Seba8282 on 9/10/2008 at 11:06 AM This issue happens because the service start up account has changed, the following article must solve the issue:http://support.microsoft.com/kb/842421But the logs requested must be

Restart IIS (Open CMD –> IISRESET). To find out more about me you can read my CV.