SQL Server 2005 Certificates

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  January 14, 2013 at 2:52 am

  #287727

  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

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  January 14, 2013 at 9:35 am

  #1576971

  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