error restore certificate

Question

error restore certificate

joujousagem2006 1602

SSCommitted

Points: 1779
More actions
August 16, 2018 at 10:09 am

#415283

I have a sql server or the backup is done in encrypted mode
the pb that I can not restore the certificate on another server
on the same server I manage to remove the certificate and restore it again
CREATE CERTIFICATE CERT_POIDW01#VOCAL FROM FILE ='\\CAEFILER03\sql-bck$\CERTIFICATE\POIDW01#VOCAL\CERT_POIDW01#VOCAL.CER' WITH PRIVATE KEY(FILE='\\CAEFILER03\sql-bck$\CERTIFICATE\POIDW01#VOCAL\PRIVATEKEY_POIDW01#VOCAL.pvk', DECRYPTION BY PASSWORD='*****');;
this Erreur
Msg 15208, Level 16, State 6, Line 1The certificate, asymmetric key, or private key file does not exist or is invalid, or you do not have the appropriate permissions for it.

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

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

joujousagem2006 1602 - Thursday, August 16, 2018 10:09 AM
I have a sql server or the backup is done in encrypted mode
the pb that I can not restore the certificate on another server
on the same server I manage to remove the certificate and restore it again
CREATE CERTIFICATE CERT_POIDW01#VOCAL FROM FILE ='\\CAEFILER03\sql-bck$\CERTIFICATE\POIDW01#VOCAL\CERT_POIDW01#VOCAL.CER' WITH PRIVATE KEY(FILE='\\CAEFILER03\sql-bck$\CERTIFICATE\POIDW01#VOCAL\PRIVATEKEY_POIDW01#VOCAL.pvk', DECRYPTION BY PASSWORD='*****');;
this Erreur
Msg 15208, Level 16, State 6, Line 1The certificate, asymmetric key, or private key file does not exist or is invalid, or you do not have the appropriate permissions for it.

Does the SQL Server service account have permissions to that UNC path?

Sue

as0917041 SSC Enthusiast Points: 127 More actions · Answer 2

Another alternative approach is to use a recovery software.