How to: Create Certificates for Service Broker Transport Security (Transact-SQL)

To set up Service Broker transport security for an instance of SQL Server, you first create a

certificate in the

database by using the

Transact-SQL statement.

This statement creates both a public key and a private key. You can also use the

statement to load an existing X.509 certificate. For more information on creating

certificates, see

CREATE CERTIFICATE. After creating the certificate, use the

statement to set the Service Broker endpoint to use the new certificate.

For more information using certificates for Service Broker transport security, see

How to: Allow

Service Broker network access by using certificates.

Create a certificate in the

database.

CREATE CERTIFICATE (Transact-SQL)

CREATE ENDPOINT (Transact-SQL)

ALTER ENDPOINT (Transact-SQL)

master
CREATE CERTIFICATE
CREATE
CERTIFICATE
CREATE ENDPOINT
ALTER ENDPOINT master
USE master
;
GO
-- Create a certificate owned by dbo.
CREATE
CERTIFICATE TransportSecurity
AUTHORIZATION [dbo]
ENCRYPTION
BY
PASSWORD
=
'**(34ader#$lqQEUer13'
WITH
SUBJECT =
'Instance certificate for transport security'
;
GO