• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

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
0
ksfok
Asked:
ksfok
  • 2
1 Solution
 
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
 
Raja Jegan RSQL 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now