Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS configuration error

Posted on 2009-05-19
3
Medium Priority
?
288 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
ID: 24422478
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
ID: 24422624
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 2000 total points
ID: 24422719
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline

879 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