Asymmetric

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Asymmetric_keys

Asymmetric_keys

Rate Topic

Display Mode

Topic Options

Author

Message

prsnn_shetty

Posted Tuesday, June 16, 2009 10:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 18, 2013 4:04 AM
Points: 272, Visits: 298

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

GSquared

Posted Tuesday, June 16, 2009 12:23 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 15,442, Visits: 9,571

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 »

Permissions