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.

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.

help: a problem to add a login in sql server

Hello,
I am trying to add a login for a Window NT user
in the SQL server but getting following error messages
Error 15401: Windows NT user or group '%s' not found.
Check the name again.
I have checked all the setting in the domain and could not
find anything wrong.
Plese some one can tell me what should I do to fix it.
Thanks
KarenHave had similar problem. Three times in one year. Some advice I've
received was check PDC & BDC sync, verify upper & lower case, but what
seemed to work for me was to reboot the server. I know this is sometimes
unacceptable, but sometimes it works.
You can do a google search also.
Bill
"Karen" <kchen@.grainscanada.gc.ca> wrote in message
news:086101c35c61$64eea390$a101280a@.phx.gbl...
> Hello,
> I am trying to add a login for a Window NT user
> in the SQL server but getting following error messages
> Error 15401: Windows NT user or group '%s' not found.
> Check the name again.
> I have checked all the setting in the domain and could not
> find anything wrong.
> Plese some one can tell me what should I do to fix it.
> Thanks
> Karen