Posts
49
Comments
50
Trackbacks
26
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!

posted on Sunday, May 29, 2005 11:03 AM Print
News