Remote Message Being Classified As Local

Hi

I am trying to deploy our service broker application into our live enviroment. I have been using the excellent service listings manager to configure security and routes when deploying to our test enviroments and had no problems. However, after having gone through the same steps in live, i can not get it working.

The messages I try sending from the remote initiating service arrives at the target service, but the ack is not sent back from the target service. I have used profiler to find out what is going on and noticed that on the target after the ack is received, a broker:message classify event occurs with an event sub class of 1 - Local. It then starts going through lots of broker: Message undeliverable events. From what I understand this means that the target service has classified that the reply to the message should be sent to a local service instead of a remote service which is not the case.

I think the remote route is set up correctly on the target server. I have run this query on the target server after one message has been sent

select r.*

from sys.conversation_endpoints e

inner join sys.routes r on e.far_service = r.remote_service_name and e.far_broker_instance = r.broker_instance

and it returns the row from sys.routes that points to the initiating service.

Can anybody help with what else I can do to solve this problem?



Antony