Home > Report Server > Report Server Cannot Decrypt The Symmetric Key Used To Access

Report Server Cannot Decrypt The Symmetric Key Used To Access

Contents

You cannot delete other posts. Close Sign In Print Article Products Article Languages Subscribe to this Article Manage your Subscriptions Problem When trying to access the Report Server page the error below is generated:  Error They were not reviewed by Microsoft and should not be treated as official Microsoft materials. If you do not have a backup key Press ‘Delete' button. news

This worked for me. 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 | Specify the Directory Database SQL Server  9. 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.

The Report Server Cannot Decrypt The Symmetric Key Sql 2008

I am seen in darkness and in light, What am I? Saturday, January 23, 2016 12:18 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. Granting database permissions to new service account only occurs if you configured the report server database connection to use the service account in the first place. Privacy statement  © 2016 Microsoft.

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 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 You cannot edit other posts. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 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

How to define a "final slide" in a beamer template? Select ‘Encryption Keys’ from the left pane. You Need a QuestionHow to Post Performance ProblemsCrosstabs and Pivots or How to turn rows into columns Part 1Crosstabs and Pivots or How to turn rows into columns Part 2 Post Monday, August 20, 2012 11:31 AM Reply | Quote 0 Sign in to vote It worked like charm..

Request a callback Latest News 9 June OPTAC3 Web - software updated Read More 20 April OPTAC3 FAQs you can use Read More 19 November 200+ Support and Product Videos Read Rsreportserverdisabled Therefore, the Report Server service cannot use the symmetric key to access the data from the report server database. Friday, September 11, 2009 6:41 PM Reply | Quote 0 Sign in to vote Thanks. Create/Manage Case QUESTIONS?

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

If I have to create 5 new data sources, I have to set the data source to each and every report. To help us diagnose, please attach the report server log files to the connect item.Thanks! The Report Server Cannot Decrypt The Symmetric Key Sql 2008 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 Delete Encrypted Content Reporting Services To do that:Open Reporting Services Configuration Manager and select 'Encryption keys' tabClick 'Delete' in 'Delete Encrypted Keys' section:You will need to reset all connection strings and db credentials for all your

Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Hi Jarret, Thank you very much for the solution. navigate to this website 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". Wait until get this result. Copyright © 2002-2016 Simple Talk Publishing. Re-set The Connection Strings And Stored Credentials On Your Reports

Chat online with an adviser Open Web Chat Want us to call you? This symmetric key is encrypted by using an asymmetric public key that corresponds to the computer and the user account that is used to run the Report Server service. If you configured the report server database connection to use a domain user account or a SQL Server database login, the connection information is not affected by the service account update. More about the author You may download attachments.

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 The Report Server Cannot Decrypt The Symmetric Key 2012 My server is a fresh install so there is NO DATA on the server at all.This is very frustrating... Please turn on JavaScript and try again.

The most common cause of this issue is changing the reporting services service account using a tool other than the Reporting Services Configuration Manager.

You cannot delete your own posts. 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 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. You Must Either Restore A Backup Key Or Delete All Encrypted Content Submit Attach a file Microsoft Connect Terms of Use Trademarks Privacy Statement © 2016 Microsoft Please wait...

I ran into this issue after moving the ReportServer and ReportServerTempDB from a working server to a different environment running Reporting Services. All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Sorry, we couldn't post your feedback right now, please try again later. click site Report Abuse.

The kicker here is it tells me that I cannot back it up and to delete all encrypted data and try again. 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 / Arts Culture / Recreation 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() In the context of this quote, how many 'chips/sockets' do personal computers contain?

Click Configure    Terms of use for this information are found in Legal Notices.

Related Articles Article Languages x Translated Content Please note that this document is a translation from You cannot post topic replies. Posted by VenkatKokulla on 7/19/2011 at 12:05 AM Hello, Do you happen to have a backup of your encryption key? 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.