CODEWITHSUNDEEP
sql-serversql-server-2008service-broker
Gaurav
Gaurav

Reputation: 915

Service Broker configuration

I have configured Service Broker communication between two SQL Server 2008 instances using Windows authentication. I am sending a message from Initiator Service to Target Service and then ending the conversation in the target. Since target is not sending a reply message back to initiator, does the Target Instance need to have any Route configured for sending system generated acknowledgement messages to Initiator? Can I only rely on conversation handle in Target instance to communicate back to Initiator?

Thanks in advance.

Upvotes: 1

Views: 369

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294407

A route is always needed in both directions. Even if you never send messages explicitly from the target, the target still needs to send implicit acknowledgements for each message received.

But in your case you are sending an explicit message: END CONVERSATION sends an http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog message.

Upvotes: 4

Related Questions