Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Single hop vs Double hop

Author  Topic 

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-10-22 : 03:28:12
Could anyone explain the difference between single hop and double hop?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-22 : 03:44:19
Single hop is jumping on one leg, and double hop is jumping in two legs.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-10-22 : 03:53:32
Thanks for the reply Peso but could you please explain more? :)
So far as I know, double hop is when a client wants to read data from a server through another server. And I know that single hop is also involved with a client and two servers (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) but can't understand the difference.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-22 : 04:07:00
quote:
Originally posted by Peso

Single hop is jumping on one leg, and double hop is jumping in two legs.



E 12°55'05.63"
N 56°04'39.26"




Well, I agree fully with Peso. As thats what we were taught as kids

However, in TCP/IP networking. When you send a message, ie from your browse to a website ie sqlteam. It goes through your ISP, whose router uses the shortest gateway to get to its destination. Each gateway is a hop, and the total number of gateways is known as the hop count.

To see how many hop counts, go to command prompt and type tracert "your destination"

e.g. tracert www.sqlteam.com

Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-22 : 04:09:15
But if in doubt, refer to Peso's definition. As more people believe in the earlier defnition
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-22 : 04:24:39
Oh, you mean hop in network context.
I am so sorry I wasn't aware of that.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-10-22 : 04:27:10
Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-10-22 : 04:43:12
No problem Peso :) every comment opens a door to a new world to me
Now I got that hop in network context differs from SQL context. Is that true?
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-22 : 05:44:00
quote:
Originally posted by Peace2007

Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?



Double ? single ? Honestly, I dont know
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-10-22 : 05:52:01
quote:
Originally posted by afrika

quote:
Originally posted by Peace2007

Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?



Double ? single ? Honestly, I dont know



Thx anyway
Here's an article, in which I think I came to an answer:
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2008-10-22 : 08:55:17
quote:
Originally posted by Peace2007

Here's an article, in which I think I came to an answer:
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx



What an excellent explanation of why no-one ever gets this working!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-22 : 10:26:36
Oh, the original question was about authentication?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -