Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Building a Distributed Service Broker Application


Building a Distributed Service Broker Application

Author
Message
Santhi Indukuri
Santhi Indukuri
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 102
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sindukuri/2797.asp
ALZDBA
ALZDBA
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8237 Visits: 8849

Good article.

Most articles only handle "local" SSB. That's the easy part !

There are many pitfalls when going remote.

I'll poste al litle script containing the dmv's,.. for SSB-problemsolving.



Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Tim Chapman-218780
Tim Chapman-218780
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 115
Good article, thank you.
Tim
Doron Grinstein
Doron Grinstein
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1

Santhi,

Navigating the MSDN documentation and other resources on the web, I find your article the most informative. No other article (which I could find) puts it together so clearly. It saved me a lot of time in doing research. I bet you spent a few days figuring out all the details of configuring service broker in a distributed environment. Thank you very much for sharing this great information with the community!

Doron Grinstein
CEO
Bitkoo
http://www.bitkoo.com


seetha.chandrapati
seetha.chandrapati
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 11
Hi Santi,

We have configured the distributed service borker environment as mentioned in the given steps.

We could not be able to see the messages which are send from the source. We are not getting any errors...

Pls. help us to find where could be the problem.

Regards,

Seetha
ALZDBA
ALZDBA
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8237 Visits: 8849
- check your sqlserver errorlog file at both servers !
- maybe the script can help you out :
Troubleshooting Service Broker (SSB) http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
minalwad
minalwad
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 28
Great information. Thank you very much. I didn't find an implementation of distibuted Service broker this elaborate on any other website!
Gabbar-416226
Gabbar-416226
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 158
This was the best I saw anywhere.

BUT ....
I am getting this error continously:
I have done this step by step thrice now.

Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.

Ports are open I can connect through Telnet.
Remote Binding is also ON.
Nothing on error logs.

The only difference is Sender is 2005 and Receiver is 2008 Server.
Does it matters?w00t
ALZDBA
ALZDBA
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8237 Visits: 8849
-what version of sql2008 are you using ?

-Did you check with sql2008 bol ?

- did you have a look at the SQL2008.Service_Broker.Samples.zip (codeplex) ?

- did you enable SSB for sql 2008 ?

http://sqlblogcasts.com/blogs/simons/archive/2008/03/11/SQL-Server-2008---Whats-new-in-the-tools.aspx

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Gabbar-416226
Gabbar-416226
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 158
Version: Microsoft SQL Server Management Studio 10.0.1300.13 ((SQL_PreRelease).080207-2350 )
Only difference from 2005 to 2008 is new templates added in 2008.

I have enabled SSB and trustworthy is ON too.

Those sample code is not for 2 servers.
I was able to successfully create a Service broker on same instance of server.
But having probelm only when there are 2 servers involved.

Also - I got the same error without creating any remote binding and then i created the
remote binding but the error was still the same.
Does this rings a bell?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search