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

Report Server Cannot Decrypt The Symmetric Key Used

Contents

To resolve this issue open the Reporting Services Configuration on the PC/Server with OPTAC3 installed on it. 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 You cannot post EmotIcons. Wednesday, May 25, 2011 11:23 AM Reply | Quote 0 Sign in to vote Wow that helped me too. have a peek here

Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Posted by Ahsan Kabir on 8/10/2015 at 9:30 PM GO to >Reporting Services Configuration Manager >Press Connect > Go to Encryption Keys page >Press the 'Delete' button .Run Browser >Run as Please enter a comment. Most of the solutions on the Web suggest to delete the encryption keys, then reconfigure the datasources.

The Report Server Cannot Decrypt The Symmetric Key Sql 2008

Reporting services can lose knowledge of the encryption key and become unable to access the encrypted information. 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 This can be beneficial to other community members reading the thread. Specify the Directory Database SQL Server  9.

HomeCurrently selectedContact usBizInsight V5BizInsight V7BizBroadcastBizInsight - DEContent Architect It looks like your browser does not have JavaScript enabled. 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 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: The Report Server Cannot Decrypt The Symmetric Key Sql 2014 A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. Are there still systems around with a /bin/sh binary? Update the Connection string field with the name of the server and the database that contains the data (‘master’ if you do not use a sql database)Example: Data Source=servername;Initial Catalog=DBnameAlso make https://support.microsoft.com/en-us/kb/955757 Or remove the connection string only.

Be sure to remove accounts that are no longer in use. Rsreportserverdisabled Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Thanks! Thank You! 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

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

Please enter a workaround. 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/ If you do not have a backup key Press ‘Delete' button. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 You must either restore a backup key or delete all encrypted content and then restart the service. Delete Encrypted Content Reporting Services How would you model 'a sphere with a shell' like object?

Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports. navigate here Do the Leaves of Lórien brooches have any special significance or attributes? 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() Monday, November 02, 2009 10:07 AM Reply | Quote 0 Sign in to vote It is helpful to me. Re-set The Connection Strings And Stored Credentials On Your Reports

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Under the Encryption Keys section, click the delete button  3. Posted by Microsoft on 2/21/2008 at 8:02 PM Thank you for filing this bug. Check This Out If the encryption key was backed up, restore the backup and test that the issue is resolved.

This is because the Microsoft Dynamics CRM 2016 Reporting Extensions Setup requires a non-local service account. The Report Server Cannot Decrypt The Symmetric Key 2012 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. Monday, August 20, 2012 11:31 AM Reply | Quote 0 Sign in to vote It worked like charm..

Thanks.

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 The Report Server service uses the symmetric key to access the encrypted data in a report server database. This can be found in Start, Programs, Microsoft SQL Server 2005. You Must Either Restore A Backup Key Or Delete All Encrypted Content My server is a fresh install so there is NO DATA on the server at all.This is very frustrating...

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 ---   All Rights ReservedPrivacy Software and Excel® Spreadsheet Software are registered trademarks of Microsoft Corporation in the United States and / or other countries. My team mate just did 2 steps to make it work. 1.)Open Reporting Services Configuration Manager Connect to your RS server Select 'Encryption Keys' from the left pane this contact form 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.

Posted by VenkatKokulla on 7/19/2011 at 12:05 AM Hello, Do you happen to have a backup of your encryption key? Thursday, May 10, 2012 8:16 AM Reply | Quote 0 Sign in to vote This helped me too. Your sollution works perfectly, and is very easy to use. 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

You cannot edit other topics. Specify the Language  8. 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 Terms of Use.

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() The kicker here is it tells me that I cannot back it up and to delete all encrypted data and try again. Posted by vinod kushwaha on 3/12/2009 at 11:50 AM I had installed SQL Server 2008 as Network Service Account but Now I have changed it to LocalSystem Account. You cannot post new polls.

Drawing a torso with a head (using \draw) Can floyd like bridge really make guitar out of tune when not blocked but not used How much time would it take for You cannot edit other posts. Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Hi Jarret, Thank you very much for the solution. 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.

You cannot send private messages. The report is showing in WEb browser and SCCM Report now... While what he did with deleting encryption keys worked, it has drawbacks of losing that encryption information and if possible, you should use the steps below to revert back to the