Post reply

Remote connecting from behind a NAT router

  • December 21, 2003 at 3:03 pm

    #64894

    I have a remote SQL7 box that keeps a backup of the main DB via replication. Everything's worked fine for years, but now I have to move the remote box behind a NAT router, meaning that it no longer has its own "over the web" IP address since that is now the router's IP address, and the remote box's IP address is an internal one like 192.168.0.3 that can be kept static as can the router's.

    There's no problem connecting to the main box from the remote one, but not vice-versa, meaning replication can't work.

    Anybody know of some way or syntax to allow the main box to connect to the remote box by a combination of the router's real IP address and the NAT address, or something else?

    Thanks!

  • December 21, 2003 at 5:11 pm

    #487373

    Your NAT router hopefully has the capability to map ports directly to systems and ports behind it. If that's the case, you'd open a port on the NAT router and point it to your remote SQL Server. You'd then point the main SQL Server to the NAT router IP and the port you opened on it.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • December 21, 2003 at 5:21 pm

    #487374

    Thanks, Brian! I'll check that out!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply