Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 service broker error for two different instances

Author  Topic 

Martyn123
Starting Member

29 Posts

Posted - 2010-12-09 : 05:44:30
Hi,

I have configured service broker between two different instances on single machine.When I run the stored procedure for initiating a dialog the message is getting populated in transmission_queue and it is not delivered to the target service and when I run the trace on the initiator instance I am getting the below message:

"Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb."
Please take ur precious time out and reply to this post as soon as possible.

Thank you
Martyn


nathans
Aged Yak Warrior

938 Posts

Posted - 2011-02-17 : 01:36:08
SQL will look in msdb.sys.routes to resolve routing information for any convos that originate external to your local instance. You will need to enable broker in msdb (and ensure local route is in place).

Nathan Skerl
Go to Top of Page

nathans
Aged Yak Warrior

938 Posts

Posted - 2011-02-17 : 01:37:34
apologies on late reply!

Nathan Skerl
Go to Top of Page
   

- Advertisement -