Home > Report Server > Report Server Cannot Decrypt Symmetric Key

Report Server Cannot Decrypt Symmetric Key

Contents

No Yes SharePoint / Project Sever / EPM Issues The failure and mistakes is everything you need to know success. 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. 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. 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 news

Submit Posted by Banketeshvar Narayan on 1/31/2016 at 6:40 AM I used the suggestion of @Ahsan "GO to >Reporting Services Configuration Manager >Press Connect > Go to Encryption Keys page >Press It helped me as well... 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". Reply Edgar says: October 3, 2013 at 10:11 pm Excelent, thanks Reply Leave a Reply Cancel reply Your email address will not be published. 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

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 On the Enterprise Vault server, in the Enterprise Vault program's group, run the Enterprise Vault Reports Configuration  4. You cannot delete your own events. Monday, October 19, 2009 2:06 PM Reply | Quote 0 Sign in to vote Helped me aswell.

Posted by Microsoft on 2/21/2008 at 8:02 PM Thank you for filing this bug. 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. Friday, May 20, 2011 10:42 AM Reply | Quote 0 Sign in to vote Hi All, Finally solved... The Report Server Cannot Decrypt The Symmetric Key Sql 2014 And it seems the only way to fix it is to delete the Encryption keys.

This will be doing the following when changing the service account from the SQL Server Reporting Services Reporting Manager: Automatically adds the new account to the report server group created on The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account If you have a backup key with extension .snk and Password, Press the ‘Restore’ button. 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! 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

Home Dashboard Directory Help Sign in SQL Server Home Downloads Feedback Surveys Thank you for your feedback! Rsreportserverdisabled You may download attachments. Tuesday, July 03, 2012 2:16 PM Reply | Quote 0 Sign in to vote Thanks, from spain !! You cannot edit your own topics.

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

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 click for more info Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online HelpBad Data. (Exception from HRESULT: 0x80090005)And I tried some solutions by googling here and there but I still couldn't solve it. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 Browse other questions tagged sql-server sql-server-2008 encryption reporting-services ssrs-2008 or ask your own question. Delete Encrypted Content Reporting Services By Reseting it will it delete the data source and I have create new one.

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 navigate to this website CALL US: 1 (866) 837-4827 Solutions Unstructured Data Growth Multi-Vendor Hybrid Cloud Healthcare Government Products Backup and Recovery Business Continuity Storage Management Information Governance Products A-Z Services Education Services Business Critical And there is one one solution that I have not tried yet. You must either restore a backup key or delete all encrypted content. Re-set The Connection Strings And Stored Credentials On Your Reports.

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 ---   As I am now at that step. 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 More about the author You have to delete the encryption key because something is wrong with the encryption.

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! The Report Server Cannot Decrypt The Symmetric Key 2012 Non-Repetitive Quine Is Area of a circle always irrational What is a satisfactory result of penetration testing assessment? Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Hi Jarret, Thank you very much for the solution.

You cannot post IFCode.

It worked for me. Thanks a bunch. You cannot edit other events. The Report Server Was Unable To Validate The Integrity Of Encrypted Data In The Database 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

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 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. This helped me. click site I backed up ReportServerDB and ReportServerTempDB just in case. 15 July 2013 at 07:16 Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Filip Czaja

It worked for me!!! Subscriptions are the people who receive automated reports in email/mapped drive. Thanks a lot from India. Friday, April 09, 2010 2:26 PM Reply | Quote 0 Sign in to vote It helped me.

Do not forget to go in to SCCM -> Administration -> Accounts and re-enter the credentials for the account you use to query SQL or it will not work properly.