Encryption Key not known

Question

Post reply

Encryption Key not known

Welsh Corgi

SSC Guru

Points: 116520
More actions
April 14, 2015 at 9:22 am

#316640

I inherited a lot of Servers to upgrade to 2014 to include an SSRS Server.
The encryption Key was never backed up and it seems that no one knows what the password is?
Do I have to manually load the reports? There are a lot of Reports.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 1

I believe you can generate a new encryption key and password. Do it before you upgrade/migrate though.

https://msdn.microsoft.com/en-us/library/ms156010.aspx

I am no SSRS expert but have been playing around a bit our dev and qa environments because we are upgrading to 2014 this year.

Jeff Moden SSC Guru Points: 1004311 More actions · Answer 2

@sarah,

Seriously off topic but I have to ask... are you related to Ed Wagner on these forums?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 3

Sarah Wagner

Hall of Fame

Points: 3178

April 22, 2015 at 9:50 am

#1792805

I doubt it 🙂

Michael L John One Orange Chip Points: 27054 More actions · Answer 4

Sarah Wagner (4/22/2015)
I doubt it 🙂

Either that, or she's not admitting it!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/