Cannot Decrypt the encrypted columns from the database backup on local machine

Question

Cannot Decrypt the encrypted columns from the database backup on local machine

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

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

Jack Corbett SSC Guru Points: 184395 More actions · Answer 1

I'd start by reading this, https://msdn.microsoft.com/en-us/library/bb964742(v=sql.120).aspx.

I haven't done much with encryption in a long time, but you have to have the same keys on both servers.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

SSRS Newbie Hall of Fame Points: 3244 More actions · Answer 2

Hi Jack,

I appreciate your quick response. I tried creating the same keys on my local SQL server as my main server has. Still no luck. Am I missing something here?

Thanks

SSRS Newbie Hall of Fame Points: 3244 More actions · Answer 3

Still stuck with this issue. Any suggestions are greatly appreciated? Need help guys. Thanks.