Announcement

Collapse
No announcement yet.

SQL 2005 STD replication through another gateway

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL 2005 STD replication through another gateway

    In our company, we have AD enviroment with Exchange 2007, ISA 2006 etc. We also have Navision which works with MS SQL STD.

    We have 2 gateways :

    192.168.27.254 (ISA) -which is for Internet users. Now, I want to configure another gateway for SQL/Navision server (which is AD member) replication with remote locations which should go through

    192.168.27.253 (Mikrotik).

    I just wanted to ask : Is it possible? Is it enough just to configure default gateway on SQL/Navision server to 192.168.27.253 (Mikrotik)

    It should be asumed that our company and remote locations are connected.

  • #2
    Re: SQL 2005 STD replication through another gateway

    Heh, I will try now to answer to myself. If somebody see that I'm wrong, please let me know.

    Our SQL/NAV server should be aviailable from Internet (for updates) and from remote locations (VPN) for database replication. Because it can't have 2 default gateways I should manually add a route for VPN locations:

    route -p add <destination network> <dest. network mask> 192.168.27.253

    Same should be done on our Exchange server because VPN users should have e-mail traffic only with central location.

    Note : Default gateway is same for all servers and it points to ISA (192.168.27.254)

    This is a snap how network should look:

    Internet <> (ISA) Central location (Mikrotik) <> VPN (secure tunnel) <> (Mikrotik) Remote location

    Am I right, theoreticaly?
    Last edited by bogi500; 20th October 2008, 09:44.

    Comment

    Working...
    X