Home > Report Server > Report Server Cannot Decrypt Symmetric Key

Report Server Cannot Decrypt Symmetric Key

Contents

To help us diagnose, please attach the report server log files to the connect item.Thanks! 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 Solution: It was the first time that I saw a clear error message that described What I should do to solve this error ?! However, I will explain How to solve it in details! For more information, see Administer a Report Server Database (SSRS Native Mode) in SQL Server Books Online. Check This Out

Home Dashboard Directory Help Sign in SQL Server Home Downloads Feedback Surveys Thank you for your feedback! You must either restore a backup key or delete all encrypted content. About Us In addition, any great website should also have great content that will be useful to your audience. Specify the SQL Reporting Services Instance  7. 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

Facebook Auto Publish Powered By : XYZScripts.com 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. Automatically updates the encryption key to include the profile information of the new account. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database

All Rights Reserved. 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 Wait until get this result. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 You reports will be fine, however your connection settings (data sources) will be gone.

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 The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Thanks! Privacy statement  © 2016 Microsoft. You cannot post replies to polls.

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 Rsreportserverdisabled 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 As I am now at that step. is a Web design and Development, SEO and Business Solutions Company based in Canada with clients from all over the globe.

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

You cannot post new polls. 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/ Refreshed the page and the error went away. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 Submit Attach a file Microsoft Connect Terms of Use Trademarks Privacy Statement © 2016 Microsoft Please wait... Delete Encrypted Content Reporting Services and will it create a new key automatically then I can access the reports?Thanks,Andri mirkywater3 Starting Member 1 Posts Posted-05/14/2012: 16:12:30 Deleting the keys will not delete any data

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. his comment is here You cannot post IFCode. Suresh Proposed as answer by Suresh Gudur Monday, January 31, 2011 3:58 PM Monday, January 31, 2011 3:38 PM Reply | Quote 0 Sign in to vote Hi, I am new I am still a beginner in SSRS, Is there another solution to fix this issue, Thanks sql-server sql-server-2008 encryption reporting-services ssrs-2008 share|improve this question edited Oct 1 '13 at 8:37 asked Re-set The Connection Strings And Stored Credentials On Your Reports.

You cannot edit other posts. 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". Thanks KumarKG, MCTS Monday, July 11, 2011 4:36 PM Reply | Quote 0 Sign in to vote Great..really helpful.... this contact form Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports.

The error says The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. The Report Server Cannot Decrypt The Symmetric Key 2012 You cannot send private messages. Bhagavad Geeta 4.14 Polyglot Anagrams Robbers' Thread Can an object *immediately* start moving at a high velocity?

We've got lots of great SQL Server experts to answer whatever question you can come up with.

No Yes SharePoint / Project Sever / EPM Issues The failure and mistakes is everything you need to know success. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! The long story here is that when changing the SQL Server Reporting Services account, you need to do that from the SQL Server Services Reporting Manager as that will prompt you The Report Server Was Unable To Validate The Integrity Of Encrypted Data In The Database 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 ---  

Also, I'd be sure to make a backup of the encryption key afterwards. Monday, October 19, 2009 2:06 PM Reply | Quote 0 Sign in to vote Helped me aswell. Rate Topic Display Mode Topic Options Author Message nasifkhannasifkhan Posted Wednesday, June 25, 2014 4:08 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, June 25, 2014 8:03 AM Points: http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-used.html 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....

Posted by billpesi on 3/5/2009 at 8:05 AM I can also tell you that on 2 seperate instance of RS2005 that this is happening and the account associated with RS has Select ‘Encryption Keys’ from the left pane.