SQL2017 Standard Edition CU12
I am trying to get encrypted backups to work on some new VMs. On the first VM I have no problem creating the master key, the certificate and it's backup and then running a db backup. My problem is on the second server. I have copied the certificate and the private key onto the second server and set MSSQLSERVER to have full rights to the files.
When I try to restore the certificate:
USE [master]; GO CREATE CERTIFICATE BackupCertificate FROM FILE = 'D:\DBEncrypt\BackupCertificate.cer' WITH PRIVATE KEY ( FILE = 'D:\DBEncrypt\BackupCertificate_PRIVATE_KEY.key' ,ENCRYPTION BY PASSWORD = 'PrivateKeyPassword' ); GO
I keep getting the following error message:
Msg 15208, Level 16, State 12, Line 23 The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it.
I have just spent half an hour on google and cannot see why this is happening.
Any ideas? It is probably something simple.