I am receiving the following errror when trying to backup the certificate I just created.
Msg 15466, Level 16, State 1, Line 2
The statement is as follows:
-- Save the certificate to disk
BACKUP CERTIFICATE certname
TO FILE = 'C:\Temp\certname.cer'
WITH PRIVATE KEY (
FILE = 'C:Temp\certname.pvk',
ENCRYPTION BY PASSWORD = 'epwd',
DECRYPTION BY PASSWORD = 'dpwd'
Searching through the web I have found entries referring to issues from encrypting databases to linked servers and referrences to this error happening because master was restored. In our case, master was not restored from any server, not even itself. I am using SQL 2005.
Thanks in advance for your assistance,