External Access

Hey all,
I am trying to access SQL Server from external site on internet. I have
set the server to listen on a random port to prevent discovery of the
server at the default 1433. I am forwarding the port through the firewall
to the SQL box. I can connect internally to the chosen port but am unable
to establish a connection externally. The server receives the connection
attempt but the reply doesn't seem to make it back. The firewall does not
perform any filtering of outgoing packets. I would have thought that NAT
would ensure responses were returned to the external network.
Are there any additional parameters or network considerations that must be
made to allow the external access?
Cheers,
Aaron Wolski.INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall
http://support.microsoft.com/?id=287932 - This article documents the
minimum TCP/IP ports that are required to communicate to SQL Server over a
firewall.
HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall
http://support.microsoft.com/?id=269882 - When you use ActiveX Data
Objects (ADO) to connect to a SQL Server 7.0 or SQL Server 2000 server that
is behind a firewall, consider the following: The firewall must be
configured to permit port 1433 incoming (or the port numbers that SQL
Server...
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Aaron Wolski" <ajwNO@.SPAMuqconnectPLEASE.net> wrote in message
news:Pine.OSF.4.58.0310071002140.5903@.fox.uq.net.au...
> Hey all,
> I am trying to access SQL Server from external site on internet. I have
> set the server to listen on a random port to prevent discovery of the
> server at the default 1433. I am forwarding the port through the firewall
> to the SQL box. I can connect internally to the chosen port but am unable
> to establish a connection externally. The server receives the connection
> attempt but the reply doesn't seem to make it back. The firewall does not
> perform any filtering of outgoing packets. I would have thought that NAT
> would ensure responses were returned to the external network.
> Are there any additional parameters or network considerations that must be
> made to allow the external access?
> Cheers,
>
> Aaron Wolski.
begin 666 1ptrans.gif
L1TE&.#EA`0`!`( ``/\SS ```"'Y! $`````+ `````!``$`0 ("A%$`.P``
`
end