Solved

SSRS - Encryption Error

Posted on 2013-01-30
1
210 Views
Last Modified: 2013-01-31
Hi all,

I have MS SQL 2008 R2 Reporting Services installed.

When I try and access the instance (I have never accessed it before and it has just been installed) I am presented with this error on the webpage:

Reporting Services 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. (rsReportServerDisabled) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors 

--------------------------------------------------------------------------------
SQL Server Reporting Services 

Open in new window


What's going on?

Cheers

K
0
Comment
Question by:techmiss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38836426
SSRS encrypts sensitive data in your SSRS database. It's done with encryption keys.
Since you don't have anything yet in your server, you can create new keys.

Go to Reporting services Configuration Manager, found under SQL Server/Configuration Tools. Check all the other settings of the server at the same time.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question