Connect through NAT router

I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill Todd
Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com
|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh