Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2012
hello to all,
 
i am confused about routing in sql server service broker.
i want to communicate 2 instances on different servers.
1 instance name is abc and other is xyz\user.
 
what should be tcp route for both.
 
for first tcp://abc:4022 for second tcp://xyz\user:4022 is it right????
Posted 9-Jan-13 21:20pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

The issue is resolved my self.
 
Sql server instance name is not used in tcp address. It should be the ip of the computer or the computer name.
so route for both should be
 
tcp://ip:4022
or
tcp://computername:4022
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Kornfeld Eliyahu Peter 420
1 OriginalGriff 303
2 Yogesh Kumar Tyagi 230
3 Gihan Liyanage 99
4 sankarsan parida 90


Advertise | Privacy | Mobile
Web02 | 2.8.140827.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100