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

Report Server Cannot Decrypt The Symmetric Key Sql 2008

Contents

It will delete your 5 data sources and the connection string /shared data sources on all 300+ of your reports. By Reseting it will it delete the data source and I have create new one. 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. 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 http://stevemattley.com/report-server/report-server-cannot-decrypt-the-symmetric-key-2008.html

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. Go to each report, click the drop down and select 'manage' Add the shared data source and save. Also can I get the connection string of all my data sources from the report server DB? Why is (a % 256) different than (a & 0xFF)?

The Report Server Cannot Decrypt The Symmetric Key Sql 2012

Tuesday, July 03, 2012 2:16 PM Reply | Quote 0 Sign in to vote Thanks, from spain !! 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 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 Blog at WordPress.com.

Thanks a lot from India. How to reply? 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 | The Report Server Cannot Decrypt The Symmetric Key Sql 2014 What happens when a wizard tries to cast a cone of cold through a wall of fire?

Comments (14) | Workarounds (0) | Attachments (0) Sign in to post a comment. it is because I couldn't change it. I was using SQL 2008 R2. 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

Posted by VenkatKokulla on 7/19/2011 at 12:05 AM Hello, Do you happen to have a backup of your encryption key? Rsreportserverdisabled Thank you. 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() Our new SQL Server Forums are live!

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. Is it possible for an diesel engine computer to detect (and prevent) a runaway condition? The Report Server Cannot Decrypt The Symmetric Key Sql 2012 Where can I read CS papers? Delete Encrypted Content Reporting Services After a bit of searching, I worked out I had to execute this command: C:Program FilesMicrosoft SQL Server80ToolsBinn> rsactivate -r -c"C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerRSReportServer.config" After which, everything worked just fine.

Enjoy 🙂 Rate this:Share this:Click to email (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Twitter (Opens in new window)Share on Facebook (Opens in navigate here Hi Filip,Your instruction to execute "Delete Encrypted Content" in RSCM helped me in this error "The report server cannot decrypt the symmetric key...".Thank you.Waldek 15 March 2012 at 08:17 lokesh said... Why are wavelengths shorter than visible light neglected by new telescopes? Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports. Re-set The Connection Strings And Stored Credentials On Your Reports

The identity account running the instance of Microsoft SQL Server Reporting Services where the Microsoft Dynamics CRM Reporting Extensions are running can’t be the local system or a virtual account. Friday, April 09, 2010 2:26 PM Reply | Quote 0 Sign in to vote It helped me. 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. http://stevemattley.com/report-server/report-server-cannot-decrypt-symmetric-key-sql-2008-r2.html Monday, January 11, 2010 8:32 PM Reply | Quote 0 Sign in to vote Thanks.

You reports will be fine, however your connection settings (data sources) will be gone. The Report Server Cannot Decrypt The Symmetric Key 2012 You must either restore a backup key or delete all encrypted content. How can I eliminate this problem?

Why dd takes too long?

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 Thanks dude.. Email check failed, please try again Sorry, your blog cannot share posts by email. The Report Server Was Unable To Validate The Integrity Of Encrypted Data In The Database I am still a beginner in SSRS, Is there another solution to fix this issue, Thanks sql-server sql-server-2008 encryption reporting-services ssrs-2008 share|improve this question edited Oct 1 '13 at 8:37 asked

Or remove the connection string only. If you do not have a backup key, you have no other choice. Can a president win the electoral college and lose the popular vote Possible repercussions from assault between coworkers outside the office How to capture disk usage percentage of a partition as this contact form Browse other questions tagged sql-server sql-server-2008 encryption reporting-services ssrs-2008 or ask your own question.

Proposed as answer by abs_dear Saturday, May 21, 2011 6:05 AM Saturday, May 21, 2011 6:05 AM Reply | Quote 0 Sign in to vote Hi, thanks a lot! 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. saved my life. You must either restore a backup key or delete all encrypted content.

You must either restore a backup key or delete all encrypted content and then restart the service A little bit scary as I had no backup! Join them; it only takes a minute: Sign up The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database Friday, May 20, 2011 10:42 AM Reply | Quote 0 Sign in to vote Hi All, Finally solved... Posted by Microsoft on 2/21/2008 at 8:02 PM Thank you for filing this bug.

Since we did not receive any log files in connection with this issue, we do not have sufficient information to investigate further. What about Existing reports Reply to Topic Printer Friendly Author Topic andritjia Starting Member Malaysia 1 Posts Posted-05/09/2012: 02:52:17 Hi All,I need someone assistance on this. share|improve this answer answered Jul 2 '14 at 18:21 wruckie 1,02311121 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Boss sends a birthday message.

You have to delete the encryption key because something is wrong with the encryption.