asked
Issue with BACKUP CERTIFICATE
Hi... I used the belwo script to encrypt and Secure native Backups using Transparent Data Encryption (TDE). USE MASTER; CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password12#' GO USE MASTER; CREATE CERTIFICATE TDECert WITH SUBJECT = 'TDE Certificate' GO USE TDE_Test GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE TDECert ; GO If I tried to backup or delete the CERTIFICATE I got this message: > Cannot find the certificate > 'TDECert1', because it does not exist > or you do not have permission. USE master; GO BACKUP CERTIFICATE TDECert1 TO FILE = 'c:\Backup\certificate_TDE_Test_Certificate.cer' WITH PRIVATE KEY (FILE = 'c:\Backup\certificate_TDE_Test_Key.pvk', ENCRYPTION BY PASSWORD = 'Password12#') DROP CERTIFICATE TDE_Test I search online about this issue ,the solution to grant permission control to user but I use my account and I have sysadmin but still couldn't grant permission and got the same message. GRANT CONTROL ON CERTIFICATE::TDECert1 TO [sa] please help me with this issue. Thank you.
Your script shows you creating TDECert and then you try to retrieve TDECert1. At least based on what you're showing us, that's the issue.
I suggest you re-examine your code to ensure the cert name is consistent (TDECert, TDECert1, TDE_Test) and then edit your question to help us see a consistent view of it.
15 People are following this question.
