请教一个service broker的问题,谢谢
我是用sa登陆的,并且已经建立了CERTIFICATE EndPointCertificateA
可是为什么下面的语句却报错了呢?
CREATE ENDPOINT ServiceBrokerEndPoint
STATE = STARTED
AS TCP (LISTENER_PORT = 4022)
FOR SERVICE_BROKER
(AUTHENTICATION = CERTIFICATE EndPointCertificateA,
ENCRYPTION = SUPPORTED
)
Msg 1088, Level 15, State 1, Line 1
Cannot find the object "EndPointCertificateA " because it does not exist or you do not have permissions.
------解决方案--------------------什么东西?没看明白.
看提示是EndPointCertificateA不存在?
------解决方案--------------------你用证书的认证方式,却没创建或拷贝证书
------解决方案--------------------直接使用windows认证
CREATE ENDPOINT [BrokerEndpoint]
STATE=STARTED
AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
FOR SERVICE_BROKER (MESSAGE_FORWARDING = DISABLED
, MESSAGE_FORWARD_SIZE = 10
, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = DISABLED)