I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i created and click "System Settings" I got this error:
The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> Microsoft.ReportingServices.Library.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> System.Security.SecurityException: Requested registry access is not allowed.
Whats funny is that on my SQL server I totally deleted the Reporting database from SQL manager, and then used "Reporting Services Configuration Manager to create a new database with a different name and I'm still getting this error. Has anyone else ever come across this? I'm stuck and confused as to why it is doing this.
Any help would be greatly appreciated.