SQL Server Service Broker疑难杂症汇总
目 录
SERVICE BROKER 异常(1): 发送方数据库中禁用 BROKER 3
SERVICE BROKER 异常(2): 对话安全(DIALOG SECURITY)证书异常 4
SERVICE BROKER 异常(3): CONNECTION HANDSHAKE FAILED 6
SERVICE BROKER 异常(4): THE TARGET SERVICE NAME COULD NOT BE FOUND 7
SERVICE BROKER 异常(5): THIS MESSAGE COULD NOT BE DELIVERED BECAUSE THE USER
DOES NOT HAVE PERMISSION TO SEND TO THE SERVICE. 8
SERVICE BROKER 异常(6): DIALOG SECURITY IS NOT AVAILABLE FOR THIS CONVERSATION. 9
SERVICE BROKER 异常(7):THIS MESSAGE COULD NOT BE DELIVERED BECAUSE IT IS A DUPLICATE 10
SERVICE BROKER 异常(8): COULD NOT FORWARD THE MESSAGE BECAUSE FORWARDING IS
DISABLED IN THIS SQL SERVER INSTANCE 12
SERVICE BROKER 异常(9): DIALOG SECURITY IS UNAVAILABLE FOR THIS CONVERSATION 13
SERVICE BROKER 异常(10): INITIATOR或 TARGET SERVICE 的授权设置及其查询 16
SERVICE BROKER 异常(11): THE SERVER PRINCIPAL “SA” IS NOT ABLE TO ACCESS THE
DATABASE “ANOTHERDBNAME” UNDER THE CURRENT SECURITY CONTEXT 19
SQL SERVER SERVICE BROKER TROUBLESHOOTING-SSB 异常问题分析及其故障排除 20