Thursday, 8 March 2012

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

No comments:

Post a Comment