Error Creating A Certificate

Hi,


I ran the script below fine in my Dev environment, bit it fails in production. Any ideas?


CREATE ENDPOINT SsbInitiatorEndpoint

STATE = STARTED

AS TCP (LISTENER_PORT = 5022)

FOR SERVICE_BROKER

(

AUTHENTICATION = WINDOWS

)

GO

CREATE MASTER KEY

ENCRYPTION BY PASSWORD = N'mypassword'

GO


CREATE CERTIFICATE SsbInitiatorCertificate

AUTHORIZATION SsbInitiatorUser

FROM FILE = N'D:SysapplMssql2005MSSQL$INSTANCENAMECertificatesSsbInitiator.cer'

WITH PRIVATE KEY

(

FILE = 'D:SysapplMssql2005MSSQL$INSTANCENAMECertificatesSsbInitiator.pvk',

DECRYPTION BY PASSWORD = 'mypassword'

)

GO


The error occurs on the CREATE CERTIFICATE statement:

Msg 15208, Level 16, State 1, Line 1

The certificate, asymmetric key, or private key file does not exist or has invalid format.

I am logged on as a local admin when running the script. The SQL Server service account is also a local admin, and the account I am logged on as is sysadmin in SQL Server. This script works fine in my Dev environment and a separate Pre-Prod environment.

I'm using SQL Server 2005 SP2.

Thanks,
Mark.