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

Report Server Cannot Decrypt The Symmetric Key Sql 2008

Contents

GO OUT AND VOTE 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 / Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! This group is specified in the access control lists (ACLs) that secure Reporting Services files. 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://rss4medics.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008-r2.php

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.... We've got lots of great SQL Server experts to answer whatever question you can come up with. What happens when a wizard tries to cast a cone of cold through a wall of fire? To find out more about me you can read my CV. visit

The Report Server Cannot Decrypt The Symmetric Key Sql 2012

Or remove the connection string only. You reports will be fine, however your connection settings (data sources) will be gone. You must either restore a backup key or delete all encrypted content. Restart IIS (Open CMD –> IISRESET).

Fill in your details below or click an icon to log in: Email (Address never made public) Name Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using Some setting must have changed. It worked for me. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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

The database login for the old account will not be removed automatically. 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 We've restricted the ability to create new threads on these forums. 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.

To help us diagnose, please attach the report server log files to the connect item.Thanks! Rsreportserverdisabled 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 My server is a fresh install so there is NO DATA on the server at all.This is very frustrating... Also, I'd be sure to make a backup of the encryption key afterwards.

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

But by doing so, I have to reset all connection strings and db credentials for all of my data sources. http://stackoverflow.com/questions/24419278/the-report-server-cannot-decrypt-the-symmetric-key-that-is-used-to-access-sensit 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 The Report Server Cannot Decrypt The Symmetric Key Sql 2012 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() Delete Encrypted Content Reporting Services This can be beneficial to other community members reading the thread.

Wait until get this result. click site Why dd takes too long? Posted by VenkatKokulla on 7/19/2011 at 12:05 AM Hello, Do you happen to have a backup of your encryption key? 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! Re-set The Connection Strings And Stored Credentials On Your Reports

Since we did not receive any log files in connection with this issue, we do not have sufficient information to investigate further. I am having this problem. The error says The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. news Sign Up today at katacoda.com Subscribe to our mailing list for the latest Docker and Deployment based news Email [emailprotected] @ben_hall on Twitter Ocelot Uproar (My Company) GitHub Slideshare Testing ASP.net

This worked for me. The Report Server Cannot Decrypt The Symmetric Key 2012 Friday, May 20, 2011 10:42 AM Reply | Quote 0 Sign in to vote Hi All, Finally solved... Please enter a comment.

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

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 Your sollution works perfectly, and is very easy to use. It helped me as well... The Report Server Was Unable To Validate The Integrity Of Encrypted Data In The Database http://www.aktechforum.blogspot.com/ Tuesday, August 11, 2015 4:03 AM Reply | Quote 0 Sign in to vote Thank you Jarret!!

Refreshed the page and the error went away. Will I get the same result if I use 18-55mm lens at 55mm (full zoom) and 55-200mm lens at 55mm (no zoom), if not, then why? 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. http://rss4medics.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008.php 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 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) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005) I understand that I need to reset my encryption