读书人

请问一个service broker的有关问题多

发布时间: 2012-01-31 21:28:41 作者: rapoo

请教一个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)

读书人网 >SQL Server

热点推荐