Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Delete EncryptionKeys. What about Existing reports
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 05/09/2012 :  02:52:17  Show Profile  Reply with Quote
Hi All,

I need someone assistance on this. At the moment I have problem when connecting Report Server. The error says

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
Bad Data. (Exception from HRESULT: 0x80090005)
And I tried some solutions by googling here and there but I still couldn't solve it. And there is one one solution that I have not tried yet. and it is deleting encryption Key. Why do I want to try deleting encryption key? it is because I couldn't change it. the button change and backup are disable and I can not restore because there is no backup.

So My concern now, If I delete Encryption. Will it delete all existing reports? and will it create a new key automatically then I can access the reports?



Starting Member

1 Posts

Posted - 05/14/2012 :  16:12:30  Show Profile  Reply with Quote
Deleting the keys will not delete any data on the server. You reports will be fine, however your connection settings (data sources) will be gone. You will have to re create the connection for the reports and subscriptions too. Subscriptions are the people who receive automated reports in email/mapped drive.

You have to delete the encryption key because something is wrong with the encryption. Some setting must have changed. If you do not have a backup key, you have no other choice. Delete, create a new one, and create new connection strings.

Not a big problem.
Go to Top of Page

Starting Member

1 Posts

Posted - 07/25/2013 :  09:20:48  Show Profile  Reply with Quote
Just one more clarification,
we are using windows auth in our report data source, do we have to deploy all reports again.

can you please provide me some info what exactly we have to follow after we delete and recreate encryption key.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000