Jefferson Elias (2/10/2016)
After reading everything and I tried to run from attached scripts, I can't manage to get it work.I'm trying to run Service Broker on two separate servers. The code to send a message to the destination works enqueues the message, but the message get stuck in transmission queue
select to_service_name,from_service_name,service_contract_name,message_type_name,transmission_status from sys.transmission_queue;
to_service_namefrom_service_nameservice_contract_namemessage_type_nametransmission_status
SampleServiceTargetSampleServiceSourceSampleContractSampleMessageDialog security is not available for this conversation because there is no remote service binding for the target service. Create a remote service binding, or specify ENCRYPTION = OFF in the BEGIN DIALOG statement.
Also tried with "WITH ENCRYPTION = OFF" but still didn't work.
Any clue ?
Hi,
Have you tried to troubleshoot using ssbdiagnose tool? example is in the scripts too. it should work. Are db servers in the same domain?
WAL.