Share via

SQL 2012 to 2019 bitlocker certificate

matteu31 512 Reputation points
2023-04-19T22:46:00.5866667+00:00

Hello,

I try to migrate SQL from 2012 to 2019 but to do it, I first need to "migrate" the certificate used to encrypt bitlocker recovery key as documented here : https://learn.microsoft.com/en-us/mem/configmgr/protect/deploy-use/bitlocker/encrypt-recovery-data#manage-the-encryption-certificate-on-sql-server-upgrade

It's ok for all step except the last one 2.c : use function [RecoveryAndHardwareCore].[RecryptKey]

Can you give me a sample on how to use the function ?

I see I need 3 parameters : old certificate name, new certificate name, ciphertext.

I don't know what to provide for ciphertext and would like a complete sample to solve this issue :)

Thanks for your answer.

Microsoft Security | Intune | Configuration Manager | Other
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Microsoft System Center | Other

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.