Solved

Service Broker Message Queue

Posted on 2012-03-26
6
1,680 Views
Last Modified: 2012-04-22
Hi all,
I have got SQL Service Broker Message Queue configured as below:
1. The initiator(client) sends data to the Target (Acting as a Forwarder)
2. The Forwarder is configured as a Gateway server (Server1) which has a public internet ip exposed to all clients
3. Another server (Server2) is configured to accept messages from Server1. Server1 and Server2 can ping each other and telnet each other

Attched the profiler at Server1, the following error message comes up at Server1 when the client sends a message:
Audit Broker Login, EventSubClass 6 - Authorization Failure
Audit Broker Login, EventSubClass 2 - Login Protocol Error
Broker:Connection, EventSubClass 4 - Closing, with TextData:"Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67."

Attached the profiler a Server2, ther following error message comes up at Server2:
Broker:Connection, EventSubClass 4 - Closing, with TextData:"An error occurred while receiving data: '10054(failed to retrieve text for this error. Reason: 1815)'.

Can someone please help us resolving these issues?

Many Thanks

Programmers
0
Comment
Question by:Programmers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 37766267
It clearly explains that the login you are using doesn't have permission on the database. Make the login a sysadmin or give proper permissions to it.
Here is a link that tells the meaning of different eventSubClasses:-
http://msdn.microsoft.com/en-us/library/ms190261.aspx
0
 

Author Comment

by:Programmers
ID: 37769924
Thanks for the link. Now, Server2 accepts the message but is not able to send the acknowlegement back to the client.  Attached the profiler at Server2 gives:
Broker:Message Undeliverable, EventSubclass 1 - Sequenced Message, TextData:'This message could not be delivered because it is a duplicate.'
Broker:Connection, EventSubClass 3 ,EventSubclass 3 - Connect Failed,TextData:'Connection attempt failed with error: '10060(A connection attemp failed because the connected party did not properly respond after a period of time, or established connection faild because connected host has failed to respond.)'.


Not really sure if this is the routing issue.

Please help

Thanks
0
 

Author Comment

by:Programmers
ID: 37792200
Can someone please give some guidance on our comment Posted on 2012-03-27 at 16:47:49.

Thanks
0
 

Accepted Solution

by:
Programmers earned 0 total points
ID: 37859315
The routing configuration was incorrect. The appropriate routes were reconfigured and the problem was resolved.

Programmers
0
 

Author Closing Comment

by:Programmers
ID: 37877402
The route configurations were incorrect.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

623 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