In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate backup from the server encrypted with TDE to the server we want to restore the database to.
You may receive this error when you try to create a new certificate from a certificate backup in the target instance.
This means that the sql server service account used by the instance we want to create the Certificate does not have the necessary privileges.
SOLUTION:
Right-click the path where the certificate and Private key is located and click Properties, then go to the Security tab, and click Add to authorize the Sql server service account.
If you cannot authorize this way, you must right-click on the files named mycertificate and myprivatekey and give the necessary authorization to the sql server service account in the security tab. After this process your certificate will be created.
