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 |