Great Circle Associates Firewalls
(August 1997)
 

Indexed By Date: [Previous] [Next] Indexed By Thread: [Previous] [Next]

Subject: Ports of Microsoft SQL Server
From: Stephen McLarey <smclarey @ on . com>
Organization: ON Technology - Cambridge
Date: Fri, 29 Aug 1997 10:24:00 -0400
To: saeed @ cyber . net . pk
Cc: firewalls @ greatcircle . com (Firewall list)
Disposition-notification-to: <smclarey @ on . com>
Importance: normal

======== Original Message ========
Hi,	

	Could Someone tell me what ports does Microsoft SQL server Listen to if
I need to open the on the Firewall.

	Even a URL for referrence would do.

Regards
Saeed
-- 
Saeed Abubakar
System Engineer
Cyber Internet Services (Pvt) Ltd.
saeed @
 cyber .
 net .
 pk
======== Fwd by: Stephen McLar ========
Setting up a client to communicate to a SQL Server over a firewall is a
simple three-step process: 

1.Make SQL Server listen on a specific port on TCP (the default is 1433) or
RPC (the default is a random port greater than 1023). You have to cycle the
server after this change. 

2.Configure your firewall server to allow traffic on the specific
<ip_address><port_number>. 

3.Make the client (on the other side of firewall) use the appropriate
connection string to talk to the <port_number> on the server. You can also
use the Client Configuration Utility to add an "Advanced" entry with the
appropriate Net-Library and connection string.

Hope this helps.
My opinions do not necessarily reflect those of On Technology.

       _\|/_
       (o o)
****oOO-(_)-OOo***********************************
*    Stephen McLarey On Guard Customer Support   *
*       Customer Support Line 800 407 7453       *
*            E-Mail smclarey @
 on .
 com              *
*               http://www.on.com                *
**************************************************

Indexed By Date Previous: definitions
From: bob bryant <rbryant @ gte . com>
Next: Re: Be careful about sending firewall log msgs via pagers - esp alpha msgs
From: ArkanoiD <ark @ paranoid . convey . ru>
Indexed By Thread Previous: Re: Ports of Microsoft SQL Server
From: Kotik Besch <kotik @ bigfoot . com>
Next: Radius for Windows NT
From: Didier CASTELAIN <castelain @ activcard . fr>

Google
 
Search Internet Search www.greatcircle.com