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