saved my life. 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 Is this the reason, the SSRS behaves like this. Filip's Technical Blog Wednesday, 25 May 2011 The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. http://rss4medics.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008-r2.php
You must either restore a backup key or delete all encrypted content and then restart the service A little bit scary as I had no backup! Delete, create a new one, and create new connection strings. If you have a backup key with extension .snk and Password, Press the ‘Restore’ button. Error rsReportServerDisabled : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database.
The kicker here is it tells me that I cannot back it up and to delete all encrypted data and try again. When does TNG take place in relation to DS9? share|improve this answer answered Jul 2 '14 at 18:21 wruckie 1,02311121 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign
also the link provided by Microsoft is for SSRS 2000 which I had looked into but does not seem to pertain to SSRS 2008 so I do not consider it a Go to each report, click the drop down and select 'manage' Add the shared data source and save. Monday, August 20, 2012 11:31 AM Reply | Quote 0 Sign in to vote It worked like charm.. Re-set The Connection Strings And Stored Credentials On Your Reports What is the significance of the robot in the sand?
This solved my problem share|improve this answer answered Oct 1 '13 at 9:48 Hassan Mokdad 2,309114171 add a comment| up vote 1 down vote I ran into this with a Microsoft The Report Server Cannot Decrypt The Symmetric Key Sql 2008 ronak2303 Starting Member 1 Posts Posted-07/25/2013: 09:20:48 Just one more clarification,we are using windows auth in our report data source, do we have to deploy all reports again.can you And there is one one solution that I have not tried yet. 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 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
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 The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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. Sign in to post a workaround. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005) I understand that I need to reset my encryption
You must either restore a backup key or delete all encrypted content. http://stackoverflow.com/questions/24419278/the-report-server-cannot-decrypt-the-symmetric-key-that-is-used-to-access-sensit This helped me. The Report Server Cannot Decrypt The Symmetric Key Sql 2012 Open Reporting Services Configuration Tool ( Programs->Microsoft SQL Server 2008 R2 -> Configuration tools -> Reporting Services Configuration Manager) Go to Encryption Keys Click Delete. The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account 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.
Monday, October 19, 2009 2:06 PM Reply | Quote 0 Sign in to vote Helped me aswell. click site This helped me. Wait until get this result. 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 Delete Encrypted Content Reporting Services
Show that the square matrix A is invertible Why "silver-tongued" for someone who is convincing? Rsreportserverdisabled Tuesday, September 25, 2012 10:30 AM Reply | Quote 0 Sign in to vote Thanks :) RedRed Thursday, October 18, 2012 8:04 PM Reply | Quote 0 Sign in to vote How do pilots identify the taxi path to the runway?
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 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 What crime would be illegal to uncover in medieval Europe? The Report Server Cannot Decrypt The Symmetric Key 2012 Next:Excel: How to use WebQuery with Excel 2007?
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 Thanks sql reporting share|improve this question asked Jun 25 '14 at 21:57 user3643480 111 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote I have had Please enter a workaround. http://rss4medics.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008.php We've got lots of great SQL Server experts to answer whatever question you can come up with.