BACKUP CERTIFICATE error Msg 15466, Level 16, State 1, Line 2

• Eduardo Olivera

  SSCommitted

  Points: 1829

  More actions

  January 23, 2013 at 4:11 am

  #273223

  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'

  )

  GO

  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,

  Eduardo

• Eduardo Olivera

  SSCommitted

  Points: 1829

  More actions

  January 23, 2013 at 5:38 am

  #1580023

  Please ignore this message, I panicked too fast. It was just a password mismatch. 🙂