Service Broker Message Queue
Posted on 2012-03-26
I have got SQL Service Broker Message Queue configured as below:
1. The initiator(client) sends data to the Target (Acting as a Forwarder)
2. The Forwarder is configured as a Gateway server (Server1) which has a public internet ip exposed to all clients
3. Another server (Server2) is configured to accept messages from Server1. Server1 and Server2 can ping each other and telnet each other
Attched the profiler at Server1, the following error message comes up at Server1 when the client sends a message:
Audit Broker Login, EventSubClass 6 - Authorization Failure
Audit Broker Login, EventSubClass 2 - Login Protocol Error
Broker:Connection, EventSubClass 4 - Closing, with TextData:"Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67."
Attached the profiler a Server2, ther following error message comes up at Server2:
Broker:Connection, EventSubClass 4 - Closing, with TextData:"An error occurred while receiving data: '10054(failed to retrieve text for this error. Reason: 1815)'.
Can someone please help us resolving these issues?