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

Report Server Cannot Decrypt The Symmetric Key

Contents

No Yes Did this article save you the trouble of contacting technical support? To help us diagnose, please attach the report server log files to the connect item.Thanks! I ran into this issue after moving the ReportServer and ReportServerTempDB from a working server to a different environment running Reporting Services. On the Enterprise Vault server, in the Enterprise Vault program's group, run the Enterprise Vault Reports ConfigurationĀ  4. check my blog

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. 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 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 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 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

it works Wednesday, December 15, 2010 6:23 AM Reply | Quote 0 Sign in to vote Thanks! On the SQL server, in the SQL program's group, run the Reporting Services ConfigurationĀ  2. 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 HomeCurrently selectedContact usBizInsight V5BizInsight V7BizBroadcastBizInsight - DEContent Architect It looks like your browser does not have JavaScript enabled.

Privacy Policy. 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 The Report Server Cannot Decrypt The Symmetric Key Sql 2014 What do I do?

Under Reporting user account, enter the Enterprise Vault Reporting account Ā  6. The Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account 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. Sign in to post a workaround.

Wednesday, December 22, 2010 9:08 PM Reply | Quote 0 Sign in to vote Hi Jarret, Thank you very much for the solution. Rsreportserverdisabled I got the following error when trying to use SQL Server Reporting Services manager:The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in This helped me. 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 Report Server Cannot Decrypt The Symmetric Key Most Likely The Service Account

You cannot upload attachments. news Sorry, we couldn't post your feedback right now, please try again later. The Report Server Cannot Decrypt The Symmetric Key Sql 2008 You may read topics. Delete Encrypted Content Reporting Services Thanks,-Lukasz Posted by Microsoft on 1/22/2008 at 9:27 AM Thank you for filing this issue.

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 click site This group is specified in the access control lists (ACLs) that secure Reporting Services files. 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. 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. Re-set The Connection Strings And Stored Credentials On Your Reports.

You must either restore a backup key or delete all encrypted content. Isnt it?Also can I get the connection string of all my data sources from the report server DB?Any help will be highly appreciated.Thanks Post #1585804 Jack Corbett Jack Corbett Posted Wednesday, The new account will be added to the RSExecRole. news The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database.

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 The Report Server Cannot Decrypt The Symmetric Key 2012 You may download attachments. You must either restore a backup key or delete all encrypted content.

You must either restore a backup key or delete all encrypted content.

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 If the Reporting Services being run is SQL Server 2005 reporting services, open Internet Explorer and browse to the Reporting Services report management web site (http://servername/reports). 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 Keyset Does Not Exist (exception From Hresult: 0x80090016) 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

Please enter a comment. You cannot send emails. 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. More about the author It worked for me.