1

Topic: Service broker queues for remote servers

Kind time of days!
The task following:
To make so that from defined  on the certain server-sender there was a possibility to send the message through queue
In defined  on other server-addressee the message in queue-addressee.
The server-addressee  to the server-sender.
Whether it is necessary to create dialogue and in addition Route and Remote service + certificates with master-key or it is possible to make without it?
Thanks!

2

Re: Service broker queues for remote servers

Valentine the uncle;
Dialogue for an exchange is necessary always, and here is how you organize safety of transport and safety of dialogue depends on your needs.

3

Re: Service broker queues for remote servers

felix_ff, whether I mean if we  the server it is possible to transfer messages as though we transferred messages in another  within the limits of one server?

4

Re: Service broker queues for remote servers

Valentine the uncle;
The broker does not use service linked server. Remaining it is necessary to create all.

5

Re: Service broker queues for remote servers

Ennor Tiegael, Thanks!

6

Re: Service broker queues for remote servers

In what there can be a reason of what service the broker on one side sends normally messages and on other side there are no messages in queue? (Different servers as the code the example from the documentation msdn) has been followed

7

Re: Service broker queues for remote servers

Valentine the uncle;
Crookedly adjusted a route for example.
How you were convinced that messages from the sending server successfully leave?

8

Re: Service broker queues for remote servers

felix_ff;
Looked  transmission_queue it empty.

9

Re: Service broker queues for remote servers

Valentine the uncle;
And in sys.conversation_endpoins at you dialogue with what status?
Whether well and at the same time instead of a monologue at you a case? After sending from the initiator I hope end conversation at once do not do?

10

Re: Service broker queues for remote servers

felix_ff;
Now to look at this   but generally yes - I do at once end , and what, ?

11

Re: Service broker queues for remote servers

Valentine the uncle;
It is the bad practice. The first the receiver should close dialogue.
Can familiarizes here the problem f&f is described, it is very probable that it is your case.
http://www.davewentzel.com/content/serv … ti-pattern

12

Re: Service broker queues for remote servers

the uncle wrote:

felix_ff;
Now to look at this   but generally yes - I do at once end , and what, ?

It is type how to send on *** the hooligan - sent and escaped
:-D

13

Re: Service broker queues for remote servers

felix_ff;
Thanks, tomorrow I can check up. I will inform on results. And how to complete dialogue on other side? After all other side does not know about that what identifier of dialogue at the initiator. Or it simply should not be closed?  I still will look , but messages at first when I launched in the first times in queue of the receiver came and I successfully could derive them, and on a trace day whether administrators  that did that still something  to queue of the receiver reached of nothing

14

Re: Service broker queues for remote servers

felix_ff,
And by the way yes - you are right the monologue turns out at me

15

Re: Service broker queues for remote servers

Valentine the uncle;
The receiver "receives" the dialogue identifier using receive
At you activation procedure (on queue of the receiver), or the program logic finding queue of the receiver should be adjusted so using receive to receive the identifier of conversation and after necessary actions with the message to close dialogue from the receiver;
And activation procedure on the side of the initiator should in case of arrival ' EndDialog ' close dialogue with the.
The concept of the correct organization of a monologue as a whole is described under the link that I resulted earlier.

16

Re: Service broker queues for remote servers

felix_ff;
Now messages hung in transmission_queue and in  from the receiver a trace a pattern:
Broker:Message Classify Could not forward the message because forwarding is disabled in this A SQL Server instance. 20 2017-09-25 10:50:50.147
Broker:Message Undeliverable The message could not be delivered because it could not be classified. Enable broker message classification trace to see the reason for the failure. sa 20 2017-09-25 10:50:50.150
Did not find  about forwarding

17

Re: Service broker queues for remote servers

the uncle wrote:

felix_ff;
Now messages hung in transmission_queue and in  from the receiver a trace a pattern:
Broker:Message Classify Could not forward the message because forwarding is disabled in this A SQL Server instance . 20 2017-09-25 10:50:50.147
Broker:Message Undeliverable The message could not be delivered because it could not be classified. Enable broker message classification trace to see the reason for the failure. sa 20 2017-09-25 10:50:50.150
Did not find  about forwarding

18

Re: Service broker queues for remote servers

Valentine the uncle;
https://technet.microsoft.com/en-us/library/ms166098 (v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms186332 (v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms166115 (v=sql.105).aspx

19

Re: Service broker queues for remote servers

felix_ff;
Thanks, but I are simple  all objects. Now normally but confuses that two messages thus come that I convrsation close on a receiving party. Did not face the such?

20

Re: Service broker queues for remote servers

Valentine the uncle;
What means two come? Two identical that send?
You consider that instruction END CONVERSATION @conversation_handle - sends the message of special type to queue of an underside of dialogue, instead of simply closes conversation on the one hand.
I.e. on good when you do

begin dialog conversation @conversation_handle
from service [initiator] to service ' target'
on contract [default]
with encryption off;
send on conversation @conversation_handle (' this is test ');
end conversation @conversation_handle;

To service queue "target" comes two messages, "this is test" and ' http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog'

21

Re: Service broker queues for remote servers

felix_ff;
Yes I about the message of this type also meant. Whether it is possible to change that it did not come to queue of the receiver?

22

Re: Service broker queues for remote servers

the uncle wrote:

felix_ff;
Yes I about the message of this type also meant. Whether it is possible to change that it did not come to queue of the receiver?

So filter on type