SSRS configuration error

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
ksfokAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
ksfokAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.