creating certficiate for FE backup

Cindy Filler

Blackbaud moved our FE sql 2019 database to Azure 2019. My backups are now encrypted and I'm trying to install the certificate and private key on my local 2019 server.

According to Blackbaud the steps I need to do are:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'xxxxx'

Download the certificate and private key from the backup panel.

And then run this command

CREATE CERTIFICATE [NightlyBackup]
FROM FILE = 'C:\\certificate\\certificate.cer'
WITH PRIVATE KEY (FILE = 'c:\\certificate\\certificate.pvk',
DECRYPTION BY PASSWORD = 'xxxxx')

I keep getting a password is invalid error. But I was able to back up the master key using the same password I'm trying to use to create the certificate. The password is 17 characters long.

Can anyone help with this? I need to update our data warehouse that we purchased from Blackbaud, but I can't get the certificate created so I can't restore the backup.

Chad Konsult

@Cindy Filler
I would be able to help update your data warehouse and bring more value to your data. Give me a call at 614-203-1718