SQL Server 2005 Certificates

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » SQL Server 2005 Certificates

SQL Server 2005 Certificates

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Pruski

Posted Monday, January 14, 2013 2:52 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, June 07, 2013 9:24 AM
Points: 850, Visits: 506

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

Andrew Pruski

Posted Monday, January 14, 2013 9:35 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, June 07, 2013 9:24 AM
Points: 850, Visits: 506

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 »

Permissions