I've hit a roadblock that I'm hoping someone hgas some ideas on.
I'm versed in SQL Server's core DB product/service but am very new amd green with regards to Reporting Services. I installed this tool and followed the instructions to the letter, differening only where appopriate such as serviname, ect. When I get to the step where I add a Data Source I get the below err msg when clicking OKK to create the new data source:
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 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)
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)
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)
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)
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)
Bad Data. (Exception from HRESULT: 0x80090005)
I looked this up and found a posting about Backup/Restore/Change & Delete of an Encryption key. I am however uncertain about any of these, about performing any action as nothing about this was listed in the Comprehensive Install Guide which I used for the install/Setup of the Health tool.
There are a few other SSRS based reports on this same server/instance which are in live use and so I must be careful what I do about my own error so as to not break anyone else's existing reports. Is there any way to reset this to it's state prior to installing the SQLH2 tool?
It looks like the encryption on this is optional. Is there any way to remove it entirely without loosing any existing reports? If it is discovered later that a consultant (or whomever added these other reports in use) has them set up wioth encryption can that encryption be added back? I'm trying to find a way to get this all working even if it means stripping out encryption and then putting it bacl.
What is PRIORITY is to not loose/break/destroy the ther reports on the same insktance of SSRS.
Thanks in adavance!
HELP??
Kindest Regards,
Just say No to Facebook!