创建证书
USE master ;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'your password' --创建主密钥
GO
CREATE CERTIFICATE A_cert --创建证书
WITH SUBJECT = 'A certificate for database Service Broker', --证书说明
START_DATE = '01/01/2008', --证书开始日期
EXPIRY_DATE = '10/31/2099' ; --证书失效日期
GO
创建Service Broker端点
CREATE ENDPOINT Endpoint_Broker_A
STATE = STARTED
AS TCP (
LISTENER_PORT=4022 --通讯中所使用的端口
, LISTENER_IP = ALL --允许所有IP
)
FOR SERVICE_BROKER(
AUTHENTICATION = CERTIFICATE A_cert --使用前面创建的证书
, ENCRYPTION = REQUIRED ALGORITHM RC4
);
--
--14.4.2节示例
--
创建路由
USE BrokerTest1;
CREATE ROUTE InstTargetRoute --创建路由
WITH SERVICE_NAME =
N'//AWDB/1DBSample/TargetService', --路由对应的服务
ADDRESS = N'TCP://MyTargetComputer:4022'; --使用的协议、端口等
