Hi,
When I run the trace On instance 2(target instance) I got the below msg:
"Could not forward the message because forwarding is disabled in this SQL Server instance." Error:9792
help me how to get rid of this problem.
I have executed the below query on initiator and on target instance(both on same machine)
USE msdb
select *
from sys.routes
;
It is returning only one row name="AutoCreatedLocal"
Is the above output perfect or else msdb should have all the user created routes to work consistently ?
Do we have to create the route(s) in the msdb database as well apart from creating those routes in user defined databases as we generally do while configuring service broker on multiple instances?
Please Please respond to this post as soon as possible.
Thanks