SQL Service Broker Queue not Processed

0
votes

I followed the SQL Service Broker Configure to configure SQL Service Broker in SQL Server 2008. But the queue is not getting processed. It remains in sys.transmission_queue. When I check the transmission status it shows the below error. 

No route matches the destination service name for this conversation. Create a route to the destination service name for messages in this conversation to be delivered.

I guess no specific needs to be configured as I am configuring all in the same database inside same server. Any ideas would help.

I checked using ssbdiagnose tool as per Remus Rusanu answer and I am geting the below error

An exception occurred on a connection to SQL Server <server name>:Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
1
sql-server-2008service-broker

1 Answers

2
votes

Run the SSB diagnostics utility: ssbdiagnose. Simplest way is to use the RUNTIME option and point it to your instance:

c:\>ssbdiagnose.exe runtime connect to -E -S <servername>

Then wait until it catches a retry and it will start investigating.

You can also try to use the CONFIGURATION option, make sure you get the service names right:

c:\>ssbdiagnose.exe -E -S <servername> -d <dbname> CONFIGURATION FROM SERVICE <fromservice> TO SERVICE <toservice>