question

Troy_2012 avatar image
Troy_2012 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.
sql-server-2012tdecertificates
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
2 Likes 2 ·
No I did an mistake with CREATE CERTIFICATE TDECert WITH SUBJECT it's also TDECert1
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.