Re: Networking terminology

Subject: Re: Networking terminology
From: Andrew Plato <gilliankitty -at- yahoo -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Fri, 18 Jun 2004 07:56:49 -0700 (PDT)


<DBennett -at- Foundationsoft -dot- com> wrote in message news:241960 -at- techwr-l -dot- -dot- -dot-

> My SMEs have told me that our users will need to "turn on" the specific
> ports they want to be able to use to access SQL. However, they've given me
> examples saying such things as "Windows Firewall is disabled on: Local Area
> Connection." If I understand correctly, "Local Area Connection" is not a
> specific port, but rather could be one of many ports.
>
> Uuggh. Is that correct? Maybe someone could just help me out by giving me a
> better definition of a "port" and how TCP/IP uses one to connect to SQL.
>
> Thanks much in advance!!
>

SQL Server, like many other applications, opens up ports for communication with
other applications. The defaults are TCP 1433 and UDP 1434. If you have a
firewall on the box turned on, these ports may be blocked. Hence, any other
system connecting to those ports would be blocked.

For a primer on TCP/UDP ports, Sun has a nice overview:
http://java.sun.com/docs/books/tutorial/networking/overview/networking.html

If you want SQL to work, you would need to alter the firewall rules and open up
ports 1433/1434. Then other applications could connect to your SQL Server.

Note, the ports that SQL use can be changed. Also, SQL can communicate using
named pipes, which uses NetBIOS as its transport protocol, which uses ports 445
(Win2K/XP) or 137/138/139 for WinNT/9x.

"Local Area Connection" is the physical network interface on the box. Could be
ethernet into a NIC or a dial-up connection. But, most likely they mean an
ethernet connection. A port is a virtual construct inside the network stack.

Andrew Plato



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

SEE THE ALL NEW ROBOHELP X5 IN ACTION: RoboHelp X5 is a giant leap forward
in Help authoring technology, featuring Word 2003 support, Content
Management, Multi-Author support, PDF and XML support and much more! http://www.macromedia.com/go/techwrldemo

COMPONENTONE DOC-TO-HELP 7 PROFESSIONAL: From a single set of Word documents, create online Help and printed documentation. New version offers yearly subscription service, Natural Search, Modular TOC Utility, Image Map Editor, Theme Designer, Context String Editor, plus more. http://www.componentone.com/doctohelp .

---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit
http://www.raycomm.com/techwhirl/ for more resources and info.



Previous by Author: TECHWR-L ADD Therapy
Next by Author: ADD/ADHD Problems and Tech Writing/Editing Careers
Previous by Thread: RE: Networking terminology (new PDF link)
Next by Thread: Re: Re: Networking terminology


What this post helpful? Share it with friends and colleagues:


Sponsored Ads