Solved

Service Broker Message Queue

Posted on 2012-03-18
3
933 Views
Last Modified: 2012-03-22
Hi all,
I have previously posted a question regarding the Target was not able to send a respond back to the Initiator.  Now I am facing other issues. When the Initiator sends a message to the Target, the Target accepts the message but not able to send an acknowlegdement back to the Initiator. Attaching the profile to the Target gives the following:
EventClass Broker:Message undeliverable, EventSubClass 1 - Sequenced Message, TextData = "This message could not be delivered because it is a duplicate."
EventClass Broker:Connection, EventSubClass 4 - Closing, TextData = 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.'

Attaching the profiler at the Initator gives the following:
EventClass Broker:Connection, EventSubClass 4 - Closing, TextData = "The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)'"

See filed attached for our network configuration between the initator and the target

Can someone please help us resolving these issues?

Many Thanks

Programmers
0
Comment
Question by:Programmers
  • 2
3 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 37736896
please clarify what sql server version, edition, servicepack you have.

Make sure it is latest Service  pack that may have fix for your problem
0
 

Author Comment

by:Programmers
ID: 37737048
Hi Eugenez,
The Target running SQL Server 2012 Enterprise edition and the Initiator running SQL Server 2012 Developer Edition.
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 37739983
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question