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

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

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 ToddBill 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

Connect across Internet through NAT router

I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine running SQL
Server. When I attempt to register the server in Enterprise Manager I use
the WAN IP address of the router as the server name. However, registration
fails with the message "SQL Server does not exist or access denied."
What am I doing wrong?
Bill ToddI found an article in BOL saying that UDP port 1434 must also be
forwarded, however, doing so did not help.
Bill Todd

Connect across Internet through NAT router

I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine running SQL
Server. When I attempt to register the server in Enterprise Manager I use
the WAN IP address of the router as the server name. However, registration
fails with the message "SQL Server does not exist or access denied."
What am I doing wrong?
Bill Todd
I found an article in BOL saying that UDP port 1434 must also be
forwarded, however, doing so did not help.
Bill Todd