Davide Mauri Blog

Experiences with SQL Server

Sql Server 2005 CREATE CERTIFICATE syntax change

I'm working on Service Broker and i've found a not documented (or maybe i haven't found the documentation?) change in the CREATE CERTIFICATE command.

The help says that you should do something like that to create your certificate from a file:

CREATE CERTIFICATE DialogCert1
FROM FILE = 'certificate.cer'
WITH PRIVATE_KEY (FILE = 'certificate.pvk', DECRIPTION BY PASSWORD  = 'password')
ACTIVE FOR BEGIN_DIALOG = ON

But this won't working, complaing about.
That's right, because the right syntax is the following one (changes with italic evidenced font):

CREATE CERTIFICATE DialogCert1
FROM FILE = 'certificate.cer'
WITH PRIVATE KEY (FILE = 'certificate.pvk', DECRIPTION BY PASSWORD  = 'password')
ACTIVE FOR BEGIN_DIALOG = ON

That's it!
Happy Broking!

Legacy Comments


Malladi Ravi Kiran
2005-07-17
re: Sql Server 2005 CREATE CERTIFICATE syntax change
Good. but including a para about creating certificates (like using MAKECERT etc) would add value, and will be of greater info.

montessori
2006-03-10
re: Sql Server 2005 CREATE CERTIFICATE syntax change
Montessori

montessori
2006-03-10
re: Sql Server 2005 CREATE CERTIFICATE syntax change
Montessori

asd
2006-03-25
Super!!
asd