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 OriginalGriff 250
1 Sergey Alexandrovich Kryukov 184
2 Rob Philpott 100
3 jlopez788 74
4 CHill60 70
0 OriginalGriff 6,837
1 Sergey Alexandrovich Kryukov 5,589
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web01 | 2.8.140721.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