Reporting services must be configured prior to installing AVIcode Advisor. That’s because AVIcode Advisor relies on the SQL Reporting Services when it comes to the reports. However, it’s not unusual that reporting services are not really configured in the customer environment simply because, in many cases, other applications just do not need reporting services.
While installing AVIcode today, I came across the following error:
Reporting Services Error
“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 and then restart the service. ”
This message says a lot, yet it does not say what else you can do. Apparently, a backup key is not always around:)
There is a knowledge base article that describes this behavior, though:
http://support.microsoft.com/kb/842421
In short, the idea is that you have to restore the user account that you used to run Reporting Server windows service originally. That will let it start, and you’ll be able to backup the key. After that, you can change the user account again and restore the key. For more details, see that KB article at MS site.
