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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » BACKUP CERTIFICATE error Msg 15466, Level 16,...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Eduardo Olivera

Posted Wednesday, January 23, 2013 4:11 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 08, 2013 10:20 AM
Points: 65, Visits: 201

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

Post #1410462

Eduardo Olivera

Posted Wednesday, January 23, 2013 5:38 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 08, 2013 10:20 AM
Points: 65, Visits: 201

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

Post #1410506

« Prev Topic | Next Topic »

Permissions