June 18, 2010 at 10:35 am
I have been asked this and should know the answer, but I am cut to the quick. I have 2 servers, one accessing another across a network. Would that be TCP? OR HTTP? Or what protocol? I don't know too much about network terminology.
June 18, 2010 at 11:03 am
TCP
June 18, 2010 at 12:10 pm
duanecwilson (6/18/2010)[/bWhat protocol does SQL Server use on a network? TCP or HTTP or FTP?
HTTP is a hypertext transfer protocol.
FTP is a file transfer protocol.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 18, 2010 at 2:34 pm
Thank you for the answeres.
June 19, 2010 at 8:09 am
also SQL Server use UDP over port 1434
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 19, 2010 at 9:53 am
Thank you for your response. Now I am really confused - The original question that I was asked said something like "Do we get the data via FTP (like some feeds) or HTTP (obviously for web sites, etc), but then, I got to thinking, when I set up a linked server, what protocol does that use, or how an application would communicate with the server or a web front end (I suppose that would be http), but I think they want to know how the "client" instance will communicate with the main server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply