SQLServerCentral / Discuss Content Posted by Santhi Indukuri / Article Discussions / Article Discussions by Author / Building a Distributed Service Broker Application / Latest Posts

RE: Building a Distributed Service Broker Application

fkucuk — Fri, 06 Jul 2012 08:42:19 GMT

Best article about this subject ever.I just wonder if it is possible to make this without using certificates.. Is it really necessary to use certificates in an domain environment?

RE: Building a Distributed Service Broker Application

Alex-181753 — Thu, 01 Dec 2011 08:09:36 GMT

[quote]- can both instances communicate using those port numbers ? (firewall, ..)- did you install the certificates correct ? [/quote]- yes by telnet- yes

RE: Building a Distributed Service Broker Application

ALZDBA — Thu, 01 Dec 2011 05:27:47 GMT

- can both instances communicate using those port numbers ? (firewall, ..)- did you install the certificates correct ?

RE: Building a Distributed Service Broker Application

Alex-181753 — Wed, 30 Nov 2011 13:49:57 GMT

Hi,I've built my SSSB application according this article but it does not work.The only thing I can get is message at transmission queue:[b]Connection handshake failed. There is no compatible authentication protocol. State 21.[/b]It looks like the problem is at end point configuration.Here is EP ddl:[code="sql"]CREATE ENDPOINT SB_Initiator_EP STATE=STARTED AS TCP (LISTENER_PORT = 4022) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE SB_EP_Initiator_Certificate, ENCRYPTION = SUPPORTED );[/code][code="sql"]CREATE ENDPOINT SB_Target_EP STATE=STARTED AS TCP (LISTENER_PORT = 4022) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE SB_EP_Target_Certificate, ENCRYPTION = SUPPORTED );[/code]Could you please advise?

RE: Building a Distributed Service Broker Application

ALZDBA — Thu, 09 Dec 2010 10:11:26 GMT

apparently something went wrong in your setup process.I would clean it up totally and start all over again.Prepare your checklist and tick the steps you perform.

RE: Building a Distributed Service Broker Application

abdul.samad.121 — Thu, 09 Dec 2010 07:32:10 GMT

Hi,When I run the trace On instance 2(target instance) I got the below msg:"Could not forward the message because forwarding is disabled in this SQL Server instance." Error:9792help me how to get rid of this problem.I have executed the below query on initiator and on target instance(both on same machine)USE msdbselect * from sys.routes;It is returning only one row name="AutoCreatedLocal"Is the above output perfect or else msdb should have all the user created routes to work consistently ?Do we have to create the route(s) in the msdb database as well apart from creating those routes in user defined databases as we generally do while configuring service broker on multiple instances?Please Please respond to this post as soon as possible.Thanks

RE: Building a Distributed Service Broker Application

abdul.samad.121 — Thu, 09 Dec 2010 04:48:02 GMT

Thanks ALZDBA for ur quick reply.When I executed the query on initiator instance I was getting is_broker_enabled = 0 so I executed the below query now I got the below given output.ALTER DATABASE msdb SET ENABLE_BROKER Q_005 name is_broker_enabled service_broker_guid msdb 1 6531971A-433F-Now I am not getting that error "broker is disabled in msdb" Now when I run the SP to start dialog on initiator again the messages are getting stuck in transmission_queue same thing is happening even when I initiate the dialog from other instance ietarget as initiator and initiator as target then also messages are getting stuck in transmission_queue on the other instance.when I checked the transmission_queue I am getting the below o/pto_broker_instance is empty, is_conversation_error=0,transmission_status is emptyWhat to do now please help me out in resolving this issue.Thanks.

RE: Building a Distributed Service Broker Application

ALZDBA — Thu, 09 Dec 2010 03:58:22 GMT

[quote][b]abdul.samad.121 (12/9/2010)[/b][hr]..."Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb."...[/quote]double check your both msdb broker setting.[code="sql"]SELECT '' as 'Q_005', name, is_broker_enabled , service_broker_guidFROM sys.databasesWHERE database_id = DB_ID('msdb') ;[/code]You can find my full ssb troubleshooting script at [url]http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/[/url]

RE: Building a Distributed Service Broker Application

abdul.samad.121 — Thu, 09 Dec 2010 03:02:24 GMT

HI,It is an awesome article(Building Distributed Service Broker) and it really helped me a lot in understanding service broker.sub: I have two sql server instances on my local machine and I have set up service broker with the help of steps mentioned in Indukuri's article but I am getting this below message when I run the trace on the initiator instance."Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb."Everytime I run the SP that initiates a dialog the message(s) is getting populated in transmission_queue and to_broker_instance column is empty.Please reply to this post as soon as possible.Thank you.

RE: Building a Distributed Service Broker Application

Sunny-138471 — Mon, 02 Mar 2009 07:49:37 GMT

Thanks SanthiYou are awesome. Your statements put together did my job rightaway. Thanks a lot reallySatish

RE: Building a Distributed Service Broker Application

Gabbar-416226 — Fri, 18 Jul 2008 10:03:09 GMT

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?

RE: Building a Distributed Service Broker Application

ALZDBA — Thu, 17 Jul 2008 14:25:51 GMT

-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 ?[url]http://sqlblogcasts.com/blogs/simons/archive/2008/03/11/SQL-Server-2008---Whats-new-in-the-tools.aspx[/url]

RE: Building a Distributed Service Broker Application

Gabbar-416226 — Thu, 17 Jul 2008 13:09:04 GMT

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:

RE: Building a Distributed Service Broker Application

minalwad — Fri, 07 Mar 2008 11:35:53 GMT

Great information. Thank you very much. I didn't find an implementation of distibuted Service broker this elaborate on any other website!

RE: Building a Distributed Service Broker Application

ALZDBA — Fri, 28 Dec 2007 04:58:55 GMT

- check your sqlserver errorlog file at both servers !- maybe the script can help you out :Troubleshooting Service Broker (SSB) [url]http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/[/url]

RE: Building a Distributed Service Broker Application

seetha.chandrapati — Fri, 28 Dec 2007 04:16:04 GMT

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

RE: Building a Distributed Service Broker Application

Doron Grinstein — Sun, 01 Apr 2007 19:00:00 GMT

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 GrinsteinCEO Bitkoohttp://www.bitkoo.com

RE: Building a Distributed Service Broker Application

Tim Chapman-218780 — Thu, 22 Mar 2007 08:57:00 GMT

Good article, thank you.Tim

RE: Building a Distributed Service Broker Application

ALZDBA — Thu, 25 Jan 2007 01:45:00 GMT

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.

Building a Distributed Service Broker Application

Santhi Indukuri — Mon, 08 Jan 2007 14:10:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sindukuri/2797.asp