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 issue should now been solved. 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 We've got lots of great SQL Server experts to answer whatever question you can come up with. news
No Yes Did this article save you the trouble of contacting technical support? You cannot delete your own events. All Rights Reserved. Report Abuse. my review here
Jack CorbettApplications Developer Don't let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. My server is a fresh install so there is NO DATA on the server at all.This is very frustrating... Turn on more accessible mode Turn off more accessible mode Skip Ribbon Commands Skip to main content Turn off Animations Turn on Animations Follow PageHeader)Sign In BizNet Software, Inc.
Some setting must have changed. Friday, September 11, 2009 6:41 PM Reply | Quote 0 Sign in to vote Thanks. Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new 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
You can use the links in the Support area to determine whether any additional information might be available elsewhere. Rsreportserverdisabled You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online HelpBad Data. (Exception from HRESULT: 0x80090005)I understand that I need to reset my encryption keys. You cannot post or upload images. 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 http://www.sqlservercentral.com/Forums/Topic1585804-150-1.aspx 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 The Report Server Cannot Decrypt The Symmetric Key Sql 2008 Reconfigure the data sources in your reports by using Report Manager. (No need if you already have a back up Key). Delete Encrypted Content Reporting Services Thanks,-Lukasz Posted by Microsoft on 1/22/2008 at 9:27 AM Thank you for filing this issue.
The-report-server-cannot-decrypt-the-symmetric-key Page ContentThe report server cannot decrypt the symmetric keyKBA-01056-C6B1T9ProblemThe following error message occurs when refreshing a report:The report server cannot decrypt the symmetric key used to access sensitive or encrypted The Report Server Cannot Decrypt The Symmetric Key 2012 The report is showing in WEb browser and SCCM Report now... You cannot vote within polls.
Menu Close Search SOLUTIONS Solutions Overview Unstructured Data Growth Multi-Vendor Hybrid Cloud Healthcare Government PRODUCTS Product Overview Backup and Recovery Business Continuity Storage Management Information Governance Products A-Z SERVICES Services Overview All Rights ReservedPrivacy Software and Excel® Spreadsheet Software are registered trademarks of Microsoft Corporation in the United States and / or other countries. Refreshed the page and the error went away. You Must Either Restore A Backup Key Or Delete All Encrypted Content Email Address (Optional) Your feedback has been submitted successfully!
Automatically updates the login permissions on the SQL Server Database Engine instance used to host the report server database. You cannot post IFCode. All Forums SQL Server 2005 Forums Analysis Server and Reporting Services (2005) Delete EncryptionKeys. click site Monday, November 02, 2009 10:07 AM Reply | Quote 0 Sign in to vote It is helpful to me.
You cannot edit HTML code. Can Trump undo the UN climate change agreement? Join them; it only takes a minute: Sign up The report server Cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database SSRS Error Can you pls explain what do you mean by : re-set the connection strings and stored credentials on your reports.
and will it create a new key automatically then I can access the reports?Thanks,Andri mirkywater3 Starting Member 1 Posts Posted-05/14/2012: 16:12:30 Deleting the keys will not delete any data Tuesday, September 25, 2012 10:30 AM Reply | Quote 0 Sign in to vote Thanks :) RedRed Thursday, October 18, 2012 8:04 PM Reply | Quote 0 Sign in to vote Automatically updates the encryption key to include the profile information of the new account. Edited by Pinoy Maximus Wednesday, October 15, 2014 1:57 PM Wednesday, October 15, 2014 1:55 PM Reply | Quote 0 Sign in to vote GO to>Reporting Services Configuration Manager >Press Connect
Post navigation ← Previous Next → SSRS Error - The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report serverdatabase Posted on November Thanks. 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). 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
You must either restore a backup key or delete all encrypted content. You cannot post new polls. It helped me as well... But by doing so, I have to reset all connection strings and db credentials for all of my data sources.My question is :Since I have more than 300 reports and 5
https://technet.microsoft.com/en-us/library/hh699754.aspx The key trigger here that is likely the root cause seen in the Haasan's question was the changing of the SQL Server Reporting Services service account without backing up the SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Cheers ! 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.