Solved

SSRS - Encryption Error

Posted on 2013-01-30
1
198 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
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

813 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now