I searched a lot about the question, but can't find solution for my situation.
We've got a Windows 2003 server that runs Advantage Database Server (ADS) through which our site connects to our accounting system. The site connects to static IP 82.xxx.xxx.147, runs several queries and disconnects. And does it every 5 minutes. Server has 2 NICs - one is for the site (192.168.5.1), another is for local network (192.168.0.1). Server connected to internet via ADSL modem/router (LAN IP 192.168.5.9), router's NAT is configured to forward port 45677 to the server.
Everything works fine, except for one thing - internet connection is not stable enough. So we got another ADSL connection with another IP address 178.xxx.xxx.181 and also forwarded that port to the server. Second modem/router's LAN IP is 192.168.5.3.
Our site is checking IP address 82.xxx.xxx.147 and if it's not responding, it tries another IP 178.xxx.xxx.181. But it doesn't connect. It looks like server rejects connections from the second router.
I tried to add second router's IP 192.168.5.9 as a second gateway in advanced TCP/IP settings of to server NIC's. But it doesn't help.
I understand, that it's something connected with routes, but I can't understand anything in those masks, metrics, gateway IPs. It's too tough for me.
I don't want the server to use any of the gateways for internet access (browser and other services). I just want it to receive incoming connections from both gateway IPs from fixed port number. Is that possible?