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

SQL Server 2005 Certificates Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 2:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 1,203, Visits: 943
Hello,

I would like some advice on cell based encryption please.

I have transferred a database which uses a certificate to encrypt certain data from a live server to a newly built server.

Now that the database is on a new server, the DECRYPTBYCERT function only returns null values when applied to the encrypted data. Please could someone confirm the best way to re-enable the function?

The steps I think I should take are:-

1. Backup Database Master Key on original server
2. Transfer backup to new server
3. Restore DMK using Server Master Key

Any help would be most appreciated.

Regards,

Andrew
Post #1406617
Posted Monday, January 14, 2013 9:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 1,203, Visits: 943
No worries no this.

All I did was open the DMK and then regenerate using the original password.

I'm able to decrypt the data now.

Andrew
Post #1406812
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse