I have a problem with a server broker conversation between two instances on the same machine.
I have used Server Listning Manager to setup the communication between the instances.
When i a try to send a dialog it stops in sys.transmissin_queue and transmission_status is "The Service Broker protocol transport cannot listen on port 4022 because it is in use by another process."
Can someone help me
/ Dan Svensson
Are you trying to set up the communication between two instances on the same host? Then only one instance can listen on port 4022, the second instance must use a different port (say 4023). Use ALTER ENDPOINT to change the listenning port of one of the instances:
ALTER ENDPOINT [broker] AS TCP (LISTENER_PORT = 4023);
Now that you changed the listener port, you must also change the route used by the other instance to point to the new port (in the database where the service is):
ALTER ROUTE [routename] WITH ADDRESS = N'TCP://hostname:4023'
HTH,
~ Remus
Tankyou
/Dan
sql
No comments:
Post a Comment