Post reply

SQL Server 2005 Certificates

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply