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

Report Server Cannot Decrypt The Symmetric Key

Contents

What do I do? You cannot send private messages. Tuesday, July 03, 2012 2:16 PM Reply | Quote 0 Sign in to vote Thanks, from spain !! To help us diagnose, please attach the report server log files to the connect item.Thanks! have a peek here

You cannot edit other posts. You cannot delete your own topics. Bookmark the permalink. 2 thoughts on “SSRS Error - The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report serverdatabase” Anonymous on February Friday, September 11, 2009 6:41 PM Reply | Quote 0 Sign in to vote Thanks. 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

You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online HelpBad Data. (Exception from HRESULT: 0x80090005) Solution   1. 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 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 It seems that this happens after machine restart (it is development machine under Win XP).I could attach the logs, but i don't see where.

If not, follow these steps: Open Reporting Services Configuration ManagerConnect to your RS serverSelect 'Encryption Keys' from the left panePress the 'Delete' button to get rid of your encrypted content After 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() Refreshed the page and the error went away. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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

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 The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account And it seems the only way to fix it is to delete the Encryption keys. 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... https://support.microsoft.com/en-us/kb/955757 Posted by vinod kushwaha on 3/12/2009 at 11:50 AM I had installed SQL Server 2008 as Network Service Account but Now I have changed it to LocalSystem Account.

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 Rsreportserverdisabled The-report-server-cannot-decrypt-the-symmetric-key Page Content​The report server cannot decrypt the symmetric keyKBA-01056-C6B1T9ProblemThe following error message occurs when refreshing a report:The report server cannot decrypt the symmetric key used to access sensitive or encrypted This is because the Microsoft Dynamics CRM 2016 Reporting Extensions Setup requires a non-local service account. It helped me as well...

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

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 Sign in to post a workaround. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 Run Browser >Run as Administrator > Type the URL and GO .Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. Delete Encrypted Content Reporting Services 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. navigate here Saturday, January 23, 2016 12:18 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. You cannot upload attachments. All Rights ReservedPrivacy Software and Excel® Spreadsheet Software are registered trademarks of Microsoft Corporation in the United States and / or other countries. Re-set The Connection Strings And Stored Credentials On Your Reports.

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 Email Address (Optional) Your feedback has been submitted successfully! If I have to create 5 new data sources, I have to set the data source to each and every report. http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-used.html You must either restore a backup key or delete all encrypted content., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted

Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports. The Report Server Cannot Decrypt The Symmetric Key 2012 You cannot edit your own events. 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.

Copyright © 2002-2016 Simple Talk Publishing.

You cannot vote within polls. If Windows authentication is being used to retrieve data, select the “Windows integrated security” radio button. http://www.aktechforum.blogspot.com/ Tuesday, August 11, 2015 4:03 AM Reply | Quote 0 Sign in to vote Thank you Jarret!! Keyset Does Not Exist (exception From Hresult: 0x80090016) Monday, October 19, 2009 2:06 PM Reply | Quote 0 Sign in to vote Helped me aswell.

You cannot post EmotIcons. To find out more about me you can read my CV. It's perfect.. 19 April 2013 at 01:15 Alex Oldman said... this contact form You must either restore a backup key or delete all encrypted content.

The new account will be added to the RSExecRole. You must either restore a backup key or delete all encrypted content. 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". Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Hi Jarret, Thank you very much for the solution.

Join them; it only takes a minute: Sign up The report server Cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database SSRS Error Your sollution works perfectly, and is very easy to use.