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!
