Sending SB messages from other than SQL Server platform

Question

Hi everyone.

I'm an experienced SQL Server administrator but (I'm shamed of saying it) I have no experience with Service Broker.

Now we are assesing the posibilty of using SB in one of our corporate applications and I wonder if its possible send messages to a SQL Server 2008 R2 Service Broker Queue from outside any SQL Server 2005/2008.

In other words is SQL Server the only tool able of sending SB messages?

I'm thinking in different servers with SQL Server 2000 and perhaps no SQL Server which sould send messages to the central SQL Server Service Broker.

Thanks in advance.

 

Answer 1

Hi jvinualzar,

The message can be sent to a Service Broker service from other applications. It is treated isolated as one end of the conversation. The message should be stored in a Service Broker queue to wait to be sent to another queue. For more information, please have a look at the architecture of the conversations of Service Broker: http://technet.microsoft.com/en-us/library/ms166049.aspx.

Best Regards,
Stephanie Lv

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Formally any application can send a SB message, but it needs to be connected to SQL Server database.

So you can't "send" a message from outside SQL Server, you can create message in any application then open connection to SQL server installed on different server and then send the message.

For example if you wish to queue some messages during wide area network outage, you need to have SQL Server on site or queue it within application.

Answer 3

Thank you so much. 

I have followed your recommendations and everything is working right. 

Several applications building messages and all of them use a SQL Server instance for send the message.