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

Report Server Cannot Decrypt The Symmetric Key 2008

Contents

If I have to create 5 new data sources, I have to set the data source to each and every report. I got the following error when trying to use SQL Server Reporting Services manager:The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in 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 Posted by Microsoft on 2/21/2008 at 8:02 PM Thank you for filing this bug. have a peek here

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. Most of the solutions on the Web suggest to delete the encryption keys, then reconfigure the datasources. Problem seems to be caused by a simple restart of the machine...Incredible there's no hotfix for that...I can provide log file if necessary.... Comments (14) | Workarounds (0) | Attachments (0) Sign in to post a comment. 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 2012

asked 2 years ago viewed 3500 times active 2 years ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 4SQL query to compare product sales by month0Decrypting data for and it is deleting encryption Key. Our new SQL Server Forums are live! Come on over!

I tried to goggled this error message and my thinking was close to the solution. You must either restore a backup key or delete all encrypted content. This worked for me. Re-set The Connection Strings And Stored Credentials On Your Reports They were not reviewed by Microsoft and should not be treated as official Microsoft materials.

Delete, create a new one, and create new connection strings. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online HelpBad Data. (Exception from HRESULT: 0x80090005)Solution:You will need to reset your encryption keys. We've got lots of great SQL Server experts to answer whatever question you can come up with. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/206bd205-3dd8-411f-a3d2-b94667f84992/the-report-server-cannot-decrypt-the-symmetric-key-used-to-access-sensitive-or-encrypted-data-in-a?forum=sqlreportingservices Apr 1 2012 12:00AM by Vikash Kumar Singh Recently I was trying to access my SSRS reports which are hosted in my system after a long vacation.

If you do not have a backup key Press ‘Delete' button. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 How would you model 'a sphere with a shell' like object? I open the Reporting Services Configuration Manager and deleted the Encrypted Content.I went to the Execution Account screen and specified my Windows Account and password.I then went to the Reporting Manager Automatically updates the login permissions on the SQL Server Database Engine instance used to host the report server database.

The Report Server Cannot Decrypt The Symmetric Key Sql 2008

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. http://stackoverflow.com/questions/24419278/the-report-server-cannot-decrypt-the-symmetric-key-that-is-used-to-access-sensit Browse other questions tagged sql reporting or ask your own question. The Report Server Cannot Decrypt The Symmetric Key Sql 2012 What is the point of update independent rendering in a game loop? The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account Non-Repetitive Quine Is there still a way to prevent Trump from becoming president?

Thanks KumarKG, MCTS Monday, July 11, 2011 4:36 PM Reply | Quote 0 Sign in to vote Great..really helpful.... navigate here Required fields are marked *Comment Name * Email * Website Post navigation Previous Previous post: ALT.NET Geek CodeNext Next post: DDD Ireland - Post Conference Home | Weblogs | Forums | 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 If you have a backup key with extension .snk and Password, Press the ‘Restore’ button. Delete Encrypted Content Reporting Services

So the Report Server is not disabled. Edited by Pinoy Maximus Wednesday, October 15, 2014 1:57 PM Wednesday, October 15, 2014 1:55 PM Reply | Quote 0 Sign in to vote GO to>Reporting Services Configuration Manager >Press Connect This helped me. http://stevemattley.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008-r2.html it works Wednesday, December 15, 2010 6:23 AM Reply | Quote 0 Sign in to vote Thanks!

You must either restore a backup key or delete all encrypted content. Rsreportserverdisabled A more detailed explanation for the resolution of this particular item may have been provided in the comments section. 14 0 Sign into vote ID 322557 Comments 14 Status Closed Workarounds This will be doing the following when changing the service account from the SQL Server Reporting Services Reporting Manager: Automatically adds the new account to the report server group created on

Open Reporting Services Configuration Tool ( Programs->Microsoft SQL Server 2008 R2 -> Configuration tools -> Reporting Services Configuration Manager) Go to Encryption Keys Click Delete.

Friday, September 11, 2009 6:41 PM Reply | Quote 0 Sign in to vote Thanks. Wait until get this result. What does "there lived here then" mean? The Report Server Cannot Decrypt The Symmetric Key 2012 You have to delete the encryption key because something is wrong with the encryption.

Search Main menu Skip to primary content Home SharePoint Server 2010 SharePoint Server 2013 Project Server 2013 SharePoint Server 2016 Project Server 2016 About Us About Blog Join Our Team Need 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() It's perfect.. 19 April 2013 at 01:15 Alex Oldman said... this contact form Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005)" DETAILS ATTACH A FILE EDIT THIS ITEM Assign To Item can only be reassigned when

Saturday, January 30, 2010 5:07 AM Reply | Quote 0 Sign in to vote Thanx Ja.it helped meRegardsSahu www.appshark.com My MSVBusinessCard Link https://www.mcpvirtualbusinesscard.com/VBCServer/81f2e667-1d54-43b7-abc3-9fb4660a0d46/interactivecard Friday, February 26, 2010 5:20 AM Reply | What about Existing reports Reply to Topic Printer Friendly Author Topic andritjia Starting Member Malaysia 1 Posts Posted-05/09/2012: 02:52:17 Hi All,I need someone assistance on this. 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 Privacy statement  © 2016 Microsoft.

Show that the square matrix A is invertible Why "silver-tongued" for someone who is convincing? 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 A connection to the database is required for all requests and processing., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

This helped me. 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. Blog at WordPress.com. Monday, November 02, 2009 10:07 AM Reply | Quote 0 Sign in to vote It is helpful to me.

Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports. Notify me of new posts via email. The ocean of knowledge is very, very deep.