locked
Can implement port forwarding using win2003 routing and remote acccess? RRS feed

  • Question

  • I have a sql server 2005 with a  internet ip address b and a computer onwindows 2003 with a internet ip address a .

    Now I want to use address "a" 's 14330 port to access sql server 2005 on ip address "b" with port 1433.

    I use router and remote access to implement this,but fail.

    in every server only have a adaptor and a ip.

    How to do it?

    Please tell me how to implement it from "routing and remote access" in detail.


    I dont want use netsh.

    Thursday, March 20, 2014 10:04 AM

Answers

  • Hi,

    I think this will not work. As we know, when a source computer send a request to SQL server, the packet should contain the following information.

    Source IP and port number (this port is a randomly generated)

    Destination IP and port 1433 (SQL by default)

    So we cannot control which port to use when connecting another service.

    Hope this helps.

    • Marked as answer by Daniel JiSun Monday, March 31, 2014 9:07 AM
    Thursday, March 27, 2014 7:22 AM

All replies