Friday, March 23, 2012

Non-standard port through router

Here's my setup. I have an SQL server machine with a local LAN ip. I have
a router with an internet IP. I configured the router to pass external port
5000 through to the sql machine's ip on port 1433. When I try to connect to
the sql server using the router's IP and port 5000 I get a timeout. I can
telnet to the router's IP and port 5000 (get a blank screen, but connection
succeeds).
Does anyone know why I would be getting a timeout? If I (internaly) connect
to the sql machine's local LAN IP port 1433 I can access the SQL server with
no problems.
Hi Lee,
If you get a blank black screen from telnet <MachineName>_or_<IP> <Port
Number>, then you have succeeded in connecting over TCP/IP to the ROUTER
port. We are not able to say it connects to SQL Server's TCP/IP port
successfully. I still think your mapping in router is not configured
correctly.
Secondly, what client tools you used to connect SQL Server? Query Analyzer?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
sql

No comments:

Post a Comment