Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Asymmetric_keys Expand / Collapse
Author
Message
Posted Tuesday, June 16, 2009 10:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 12:26 AM
Points: 272, Visits: 359
Hi,

I have restored a back-up from a Sql server instance to another,but
was not able to decrypt using the asymmetric key even i tried recreating the master key and asymmetric key but was of no use.Please let me know if there is some way through which data can be decrypted.

Regards
Prasanna.
Post #735855
Posted Tuesday, June 16, 2009 12:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
I think you can't re-create the master key. I think you need to migrate it. If I remember correctly, in MSDN/BOL articles on encryption, it has data on how to do that.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #735924
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse