0

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.

Improve this question

1 Answer 1

Reset to default
0

You should not be using Reporting Services Configuration Manager with SSRS 2012 or higher when in SharePoint integrated mode. That is why you're seeing this error. Delete your existing SSRS Service Application and databases, then create a new SSRS Service Application with new databases.

Improve this answer
13
  • The only thing i have that is 2012 is SQL manager. My SharePoint Enterprise is actually 2010, sorry I should of pointed that out. So I create the service application first THEN the database? I've been creating the database first then the service application, does that matter?
    – spassler
    Jan 22, 2016 at 21:19
  • When you create the Service Application, it will create the database as well. You can name the database, or leave the database name as the default. You should not use any tools outside of SharePoint to create or manage SSRS databases when in SharePoint integrated mode.
    – user6024
    Jan 22, 2016 at 21:26
  • I just tried it but when i try to go to system settings after i created it using SharePoint only, i still have the same error as above. Is this because there is another report database still somewhere?
    – spassler
    Jan 22, 2016 at 21:30
  • SSRS has 3 databases, they should all start with the same name (e.g. ReportingServices, ReportingServices_Temp, ReportingServices_Alerting).
    – user6024
    Jan 22, 2016 at 22:15
  • Correct. All were removed and when I created a totally new service it created new databases, but i still got the same error, so not sure why it's happening.
    – spassler
    Jan 22, 2016 at 22:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.