SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

andritjia
Starting Member

Malaysia
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?



Thanks,

Andri

mirkywater3
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

ronak2303
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000