TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
<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.
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.
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.
