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

Report Server Cannot Decrypt The Symmetric Key That Is Used

Contents

This helped me. Comments (14) | Workarounds (0) | Attachments (0) Sign in to post a comment. Hope this helps.Venkat Posted by lukek on 11/10/2010 at 7:32 AM happens regulalry for me too - the server isnt used much - reapplying the key (even after regenerating it) fixes Automatically updates the login permissions on the SQL Server Database Engine instance used to host the report server database. have a peek here

Posted by Teo Lachev on 2/22/2008 at 4:34 AM Lukasz,I'll keep an eye on this issue with CTP6 and re-open it if I can repro. 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 Required fields are marked *Comment Name * Email * Website Post navigation Previous Previous post: ALT.NET Geek CodeNext Next post: DDD Ireland - Post Conference 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. 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 2012

Please turn on JavaScript and try again. Thank you Thursday, May 15, 2014 4:44 PM Reply | Quote 0 Sign in to vote Hi Guys! You must either restore a backup key or delete all encrypted content. 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

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 Submit Attach a file Microsoft Connect Terms of Use Trademarks Privacy Statement © 2016 Microsoft Please wait... 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 Re-set The Connection Strings And Stored Credentials On Your Reports. You must either restore a backup key or delete all encrypted content.

If like in my scenario, you happen to know what the previous service account user was, the fix is to change the SQL Server Report Service account user back to the The Report Server Cannot Decrypt The Symmetric Key Sql 2008 This helped me. Thanks KumarKG, MCTS Monday, July 11, 2011 4:36 PM Reply | Quote 0 Sign in to vote Great..really helpful.... https://support.microsoft.com/en-us/kb/955757 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

You must either restore a backup key or delete all encrypted content. The Report Server Cannot Decrypt The Symmetric Key Sql 2014 Monday, August 12, 2013 8:02 PM Reply | Quote 0 Sign in to vote \o/ thank you \o/ Wednesday, February 26, 2014 1:37 PM Reply | Quote 0 Sign in to Thanks. 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

The Report Server Cannot Decrypt The Symmetric Key Sql 2008

Why is the 'You talking to me' speech from the movie 'Taxi Driver' so famous? go to this web-site magento 2: How to use the order by and limit clause in sql query What is the most someone can lose the popular vote by but still win the electoral college? The Report Server Cannot Decrypt The Symmetric Key Sql 2012 Specify the SQL Reporting Services Instance  7. The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account They were not reviewed by Microsoft and should not be treated as official Microsoft materials.

Please enter a comment. navigate here 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. No Yes How can we make this article more helpful? You must either restore a backup key or delete all encrypted content. Delete Encrypted Content Reporting Services

Thanks. 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 Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-used.html You cannot post events.

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 Rsreportserverdisabled You must either restore a backup key or delete all encrypted content. 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

If the encryption key was backed up, restore the backup and test that the issue is resolved.

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 If you have a backup key with extension .snk and Password, Press the ‘Restore’ button. If I have to create 5 new data sources, I have to set the data source to each and every report. The Report Server Cannot Decrypt The Symmetric Key 2012 Your sollution works perfectly, and is very easy to use.

This is because the Microsoft Dynamics CRM 2016 Reporting Extensions Setup requires a non-local service account. Would we find alien music meaningful? Select ‘Encryption Keys’ from the left pane. this contact form 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

Ballpark salary equivalent today of "healthcare benefits" in the US? 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. Error rsReportServerDisabled : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You cannot edit other posts.

How can I eliminate this problem? Report Abuse. Browse other questions tagged sql-server sql-server-2008 encryption reporting-services ssrs-2008 or ask your own question. You cannot post replies to polls.

For more information, see Administer a Report Server Database (SSRS Native Mode) in SQL Server Books Online.