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

Report Server Cannot Decrypt Symmetric Key Sql 2008 R2

Contents

It helped me as well... I tried to see one of the reports which I had developed for my personal use. 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 will have to fix each report one-by-one, but there is a faster way to fix your individual reports than editing them in BIDS or ReportBuilder3. Check This Out

Related 2Administrator cannot administer sql server reporting services7How to control what users can decrypt SQL Server Symmetric Key Encryption5Is it possible to specify the data source during execution of an SSRS I have changed the service account but cannot change it back cause it tells me I need to backup the encryption key. Technorati Tags: SQL Server Posted on May 1, 2008Author Ben HallCategories SQL Server 2 thoughts on “SQL Server Reporting Services - rsReportServerDisabled error” Anonymous says: July 21, 2008 at 5:19 pm They were not reviewed by Microsoft and should not be treated as official Microsoft materials.

The Report Server Cannot Decrypt The Symmetric Key Sql 2012

You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) In the Microsoft connect site I found this problem described. The report server cannot decrypt the symmetric key - by Teo Lachev Status : Closed as Not Reproducible Not Reproducible The product team could not reproduce this item with the Run Browser >Run as Administrator > Type the URL and GO .Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. If I have to create 5 new data sources, I have to set the data source to each and every report.

Where can I read CS papers? Please enter a workaround. Notify me of new posts via email. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 Is this the reason, the SSRS behaves like this.

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() asked 2 years ago viewed 3502 times active 2 years ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 4SQL query to compare product sales by month0Decrypting data for How do I make an alien technology feel alien? useful source 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()

Cheers ! Rsreportserverdisabled Mimsy were the Borogoves - why is "mimsy" an adjective? magento 2: How to use the order by and limit clause in sql query Zener diodes in glass axial package - not inherently shielded from photoelectric effect? It does definately seem that if you don't use RS for a while (which sometimes happens with my local development copy), it blows up when you try to start it.The frequency

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

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 http://stackoverflow.com/questions/24419278/the-report-server-cannot-decrypt-the-symmetric-key-that-is-used-to-access-sensit If not, follow these steps: Open Reporting Services Configuration ManagerConnect to your RS serverSelect 'Encryption Keys' from the left panePress the 'Delete' button to get rid of your encrypted content After The Report Server Cannot Decrypt The Symmetric Key Sql 2012 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? Delete Encrypted Content Reporting Services Tuesday, November 17, 2009 3:40 AM Reply | Quote 0 Sign in to vote HI Jarret,I have same issue...I deleted the encrypted keys.earlier i havnt deployed any report to this reportserver.but

What is a satisfactory result of penetration testing assessment? his comment is here asked 3 years ago viewed 9214 times active 8 months ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Get the weekly newsletter! How can I eliminate this problem? Deleting the encryption keys was not an option and I knew the password used to create the encryption key, so I took a backup of the key from the working server Re-set The Connection Strings And Stored Credentials On Your Reports

Create an account dedicated to the service and mark it as "password never expires". You can use the links in the Support area to determine whether any additional information might be available elsewhere. Thank you Thursday, May 15, 2014 4:44 PM Reply | Quote 0 Sign in to vote Hi Guys! http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-2008.html This group is specified in the access control lists (ACLs) that secure Reporting Services files.

Why dd takes too long? The Report Server Cannot Decrypt The Symmetric Key 2012 Also, I'd be sure to make a backup of the encryption key afterwards. Comments (14) | Workarounds (0) | Attachments (0) Sign in to post a comment.

This is needed if you are deleting the Encrypt content file in Reporting Services Configuration Manager.

Sign in to post a workaround. Most of the solutions on the Web suggest to delete the encryption keys, then reconfigure the datasources. 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 The Report Server Was Unable To Validate The Integrity Of Encrypted Data In The Database So I went to the properties and re-applied Windows Integrated Security.

Monday, October 19, 2009 2:06 PM Reply | Quote 0 Sign in to vote Helped me aswell. A more detailed explanation for the resolution of this particular item may have been provided in the comments section. 14 0 Sign into vote ID 322557 Comments 14 Status Closed Workarounds Go to each report, click the drop down and select 'manage' Add the shared data source and save. navigate here 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

I am not getting what to do in that step. -Ayaz Wednesday, September 14, 2011 2:40 PM Reply | Quote 0 Sign in to vote Thanks., it helps! Should I allow my child to make an alternate meal if they do not like anything served at mealtime? The answer by VenkatKokulla fixed my problem: "Do you happen to have a backup of your encryption key? Restart IIS (Open CMD –> IISRESET).

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 You must either restore a backup key or delete all encrypted content. I write on things which I come across in my daily life and feel to share it with the people across the world. Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. ---------------- Sunday, December 05, 2010 1:23 PM Reply

The report is showing in WEb browser and SCCM Report now... When you change the user account that is used to run the Report Server service, the report server cannot use the asymmetric public key to decrypt the symmetric key. Reporting Services, Integration Services and Analysis Services.