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.
| 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 youMartyn |
|
|
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 |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2011-02-17 : 01:37:34
|
| apologies on late reply!Nathan Skerl |
|
|
|
|
|
|
service broker error for two different instances