December 9, 2010 at 10:11 am
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.
Johan
Learn to play, play to learn !
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[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 30, 2011 at 1:49 pm
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:
Connection handshake failed. There is no compatible authentication protocol. State 21.
It looks like the problem is at end point configuration.
Here is EP ddl:
CREATE ENDPOINT SB_Initiator_EP
STATE=STARTED
AS TCP (LISTENER_PORT = 4022)
FOR SERVICE_BROKER
(
AUTHENTICATION = CERTIFICATE SB_EP_Initiator_Certificate,
ENCRYPTION = SUPPORTED
);
CREATE ENDPOINT SB_Target_EP
STATE=STARTED
AS TCP (LISTENER_PORT = 4022)
FOR SERVICE_BROKER
(
AUTHENTICATION = CERTIFICATE SB_EP_Target_Certificate,
ENCRYPTION = SUPPORTED
);
Could you please advise?
December 1, 2011 at 5:27 am
- can both instances communicate using those port numbers ? (firewall, ..)
- did you install the certificates correct ?
Johan
Learn to play, play to learn !
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[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 1, 2011 at 8:09 am
- can both instances communicate using those port numbers ? (firewall, ..)
- did you install the certificates correct ?
- yes by telnet
- yes
July 6, 2012 at 8:42 am
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?
July 7, 2013 at 11:25 pm
Best instructions I've ever found (via Google) of setting up SSSB between two servers (or instances).
But ... The instructions terminate too early which leaves things in a SSSB Anti-Pattern called "Fire and Forget".
i.e. the InitiatorQueue of DatabaseA should do a RECIEVE of the messages and END CONVERSATION so that SSSB cleans up all it internal stuff. I.e. the message exchange must have an END CONVERSATION on BOTH sides.
If you don't do this your databases (both initiator and target) will grow enormously (depending on message frequency and/or size).
Remus explains: http://rusanu.com/2006/04/06/fire-and-forget-good-for-the-military-but-not-for-service-broker-conversations/[/url]
Maybe an update would be helpful as one of our brave souls followed the instructions six months ago and is now a bit red faced as he has to go back to the solution and clean it all up. :w00t:
June 3, 2015 at 7:26 am
really useful, actually worked. Now onto integrating this...
August 20, 2016 at 10:16 am
Thank you very much for your detailed article. It is not often that I make the effort of registering just to rate an article, but yours is exactly what I needed and I got it working first time following your instructions. Prior to reading your post, I struggled through 4-5 different articles, but to no avail.
I do have a question though, although I think I might be too late to expect a reply. In your post you talk about setting up two different security
configurations
1. Transport Security
2. Dialog Security
I setup both, and of course I got it working, but I still have this idea that you meant to you can use either or. Is both required?
Regards,
Fernando de Bruyn
January 8, 2020 at 5:52 pm
Thank you very much! I followed the instructions to the T and I got it to work between 2 different servers, but in the same network. However my goal is to do it in servers on different networks, so would I have to use the public IP address?
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply