Friday, February 24, 2012

Help: Messages stuck in sys.transmission_queue

For some reason the messages are stuck at sys.transmission_queue. The transmission status seems to be null. I verified all the Queues and they hae the values of (is_receive_enables = 1, is_enqueue_enabled = 1, is_activation_enabled = 0)

I have set up the service broker on different domain and have bidirectional ports open to receive messages.

I can send and receive messages, when I run the same service broker setup scripts at the machines that belongs to same domain .

any help appreciated.

Do you have anything picking up the messages from the queues? You have is_activation_enabled = 0. Have you tried associating an sp with a queue ?

Tim|||

Thanks Tim... I figured out the issue. The 2 servers we used are in different domain and have firewall. The ports open for service broker were not bidirectional.

No comments:

Post a Comment