RE: problems with client access from an external IP
From: Gary Whitley [MSFT] (garyw_at_online.microsoft.com)
Date: 11/25/03
- Previous message: DonnaJ: "recovery of SQL Server 2000 replication database"
- In reply to: Jeff: "problems with client access from an external IP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 25 Nov 2003 15:18:58 GMT
Hi Jeff,
I believe the issue you observe is related to firewall configuration. SQL
Server, by default, listens on TCP port 1433 for incoming connections. It
will respond back to the client on another TCP port negotiated with the
client. Therefore, the firewall must be configured to allow incoming
packets on port 1433 or any other port configured for the SQL Server
instance. Also, the firewall must be configured to allow outgoing packets
on TCP ports 1024 through 5000.
The ports used are discussed in Knowledge Base article 287932. This is
found at http://support.microsoft.com/default.aspx?scid=kb;en-us;287932.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.
- Previous message: DonnaJ: "recovery of SQL Server 2000 replication database"
- In reply to: Jeff: "problems with client access from an external IP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
