Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Building a Distributed Service Broker Application Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 11:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 4:43 PM
Points: 57, Visits: 249
Best instructions I've ever found (via Google) of setting up SSSB between two servers (or instances).

But ... The instructions terminate too early which leaves things in a SSSB Anti-Pattern called "Fire and Forget".

i.e. the InitiatorQueue of DatabaseA should do a RECIEVE of the messages and END CONVERSATION so that SSSB cleans up all it internal stuff. I.e. the message exchange must have an END CONVERSATION on BOTH sides.

If you don't do this your databases (both initiator and target) will grow enormously (depending on message frequency and/or size).

Remus explains: http://rusanu.com/2006/04/06/fire-and-forget-good-for-the-military-but-not-for-service-broker-conversations/

Maybe an update would be helpful as one of our brave souls followed the instructions six months ago and is now a bit red faced as he has to go back to the solution and clean it all up.
Post #1471040
Posted Wednesday, June 3, 2015 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 5, 2015 4:56 AM
Points: 3, Visits: 118
really useful, actually worked. Now onto integrating this...
Post #1691175
Posted Saturday, August 20, 2016 10:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 20, 2016 10:06 AM
Points: 1, Visits: 0
Thank you very much for your detailed article. It is not often that I make the effort of registering just to rate an article, but yours is exactly what I needed and I got it working first time following your instructions. Prior to reading your post, I struggled through 4-5 different articles, but to no avail.

I do have a question though, although I think I might be too late to expect a reply. In your post you talk about setting up two different security
configurations

1. Transport Security
2. Dialog Security

I setup both, and of course I got it working, but I still have this idea that you meant to you can use either or. Is both required?

Regards,
Fernando de Bruyn
Post #1811014
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse