Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BACKUP CERTIFICATE error Msg 15466, Level 16, State 1, Line 2 Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 4:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 97, Visits: 308
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
Posted Wednesday, January 23, 2013 5:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 97, Visits: 308
Please ignore this message, I panicked too fast. It was just a password mismatch.
Post #1410506
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse