Solved

SSRS configuration error

Posted on 2009-05-19
3
275 Views
Last Modified: 2012-05-07
I have attached a picture of what might be the cause of an SSRS Configuration error:

Restoring Encryption Key

Thanks for any help,


RSERROR.jpg
0
Comment
Question by:ksfok
  • 2
3 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
You need to backup the Encryption Key and then use it while Restoring.
More info on the steps involved below

http://msdn.microsoft.com/en-us/library/ms157275.aspx
0
 

Author Comment

by:ksfok
Comment Utility
Can the same key be used for multiple times and across local system, network service, or local service? What could we do if the key was lost?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
Comment Utility
You can backup a key for an instance once and you can use it for restoring in all machines where you try to use that report instance.

As it is mentioned earlier in the link above:

You only need to back up one copy of the symmetric key. There is a one-to-one correspondence between a report server database and a symmetric key. Although you only need to back up one copy, you might need to restore the key multiple times if you are running multiple report servers in a scale-out deployment model. Each report server instance will need its copy of the symmetric key to lock and unlock data in the report server database.

<< What could we do if the key was lost? >>
Store the key in a secure location and if you lose it you can backup the key again but if that changes, then you need to change in all machines where you have restored the old key.
Hence it is advisable to keep the key safe.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 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

10 Experts available now in Live!

Get 1:1 Help Now