开发者

Error when issuing BACKUP CERTIFICATE

I am creating a certificate in one of my databases, which works without a problem. However, when I try to back up that certificate so that I can port it over to another database I receive the following error message:

An error occurred during decryption.

Here's my backup statement:

BACKUP CERTIFICATE test_certs TO FILE = 'C:\test_certs.cer'
WITH PRIVATE KEY (FILE = 'C:\test_certs.pvk',
    ENCRYPTION BY PASSWORD = 'SomePassw0rd',
    DECRYPTION BY PASSWORD = 'SomeOtherPassw0rd')

Just to be safe, I've checked that the server has a C:\ drive with:

EXEC xp_cmdshell 'DIR C:\'

I also confirmed that I could write to the location with:

EXEC xp_cmdshell 'echo test > C:\test.txt'

So, unless the security used by BACKUP CERTIFICATE is different than tha开发者_Go百科t for xp_cmdshell (which is entirely possible), it's not an issue with writing to the disk.

Google turned up only a few results and none of them seemed to address this problem. Has anyone else seen this before? Any idea what the issue is?

Thanks!


Sigh... apparently the DECRYPTION BY PASSWORD (but not the ENCRYPTION BY PASSWORD) must match the ENCRYPTION BY PASSWORD of the CREATE CERTIFICATE command. I'll leave this here in case anyone else in the future has the same brain hiccup that I just did.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜