Post reply

SQL Service Broker error (2K8)

  • January 23, 2010 at 11:07 am

    #218511

    Let me start by saying thank you for any and all responses. Also, I am a newer database developer and learning, so please make your answers as detailed and simple as possible.

    I was charged with setting up service broker (SSB). The idea is that there will be multiple locations, each with a SQL Server and one central location also with a SQL Server. The locations will use SSB to communicate with one another through the central server. The architecture is not my idea, I am merely responsible for implementing it. Replication is out of the question here - per my architect.

    I have a VM envinroment and set up 4 machines in the same domain and configuration - LOC1, LOC2, LOC3 and CENT. I've gone through all the steps regarding the creation of endpoints, db users, message types, contracts, etc.

    I tried to send a message from LOC2 to CENT and another message from LOC3 to CENT, but get the following error:

    An error occurred while receiving data:

    '10054(An existing connection was forcibly closed by the remote host.)'.

    When I do a SELECT * FROM sys.transmission_queue on LOC2 or LOC3, I can see the messages in there, but they don't make it to CENT. If I run the same query on CENT, I see nothing.

    One of the theories is that since I'm using a virtual environment and all the SSBs are listening on port 4022, that they are all technically listenting on the same physical port since there is only one physical machine.

    If this is the case, I'm not sure how to overcome it unless I can make SSB listen on different ports. If that is the answer, I'm not sure how to do it.

    Your thoughts/theories/and or solutions would be greatly appreciated.

    Thanks!

  • January 23, 2010 at 3:40 pm

    #1107841

    Unfortunately, I don't have an answer for you.

    But the Service Broker subject in general is not really one of the top issues discussed in this forum (I don't know why).

    Maybe one of the following links will increase the chances of getting your issue resolved:

    http://social.msdn.microsoft.com/Forums/en/sqlservicebroker/threads

    http://rusanu.com/2005/12/20/troubleshooting-dialogs/


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply