Not on the same internal port number. When a machine outside of your LAN
tries to connect to your SQL. They will initiate a session with the public
IP on port 1433. Which internal machine will get the connection? Think of
the confusion created when two people in a house pick up different
extensions on the same phone line. The caller will not be able tell who they
are talking to.
Your choices are:
1) change the port on the second SQL server (try something like 1434 - does
anyone else have feedback on what port to use?).
2) Get an additional public IP.
In a nut shell:
One external IP + two internal IP = must be different ports
Two external IP + two internal IP = Can be same port
James W. McKeand
From: marcelo [mailto:marcelo at bmsnet dot com dot br]
Sent: Tuesday, September 14, 2004 5:13 PM
To: James W. McKeand
Subject: Re: [m0n0wall] MultiNatRedir
Tks about your response.
But i have only one public ip, i want redirect to two internals private ips
Mono ( just 1 public ip only)
--if ip pub 1---->!----!------(nat) ip private 1 port 1433
! ! ( 1 server sql )
--if ip pub 2---->! !-----(nat) ip private 2 port 1433
------ ( 2 server sql )
----- Original Message -----
From: "James W. McKeand" <james at mckeand dot biz>
To: "'marcelo'" <marcelo at bmsnet dot com dot br>
Cc: <m0n0wall at lists dot m0n0 dot ch>
Sent: Tuesday, September 14, 2004 5:09 PM
Subject: RE: [m0n0wall] MultiNatRedir
> Is the one public IPs you mentioned that worked your WAN IP? If so, you
> to add the second IP on the Server NAT tab. You may also need to use Proxy
> ARP, i.e. to reply to ARP requests to multiple IPs on WAN interface.
> James W. McKeand
> -----Original Message-----
> From: marcelo [mailto:marcelo at bmsnet dot com dot br]
> Sent: Tuesday, September 14, 2004 4:12 PM
> To: m0n0wall at lists dot m0n0 dot ch
> Subject: [m0n0wall] MultiNatRedir
> Hi all,
> It's possible...
> I have two sqlserver in my private network and i would like redirect some
> publics ips to one server and others ips to another, like this...
> 126.96.36.199 port 1433 -> 192.168.0.5 port 1433
> 188.8.131.52 port 1433 -> 192.168.0.7 port 1433
> with one nat redirect i did(works good), but when i add second role its
> work, why?
> so if any have one tutorial or help.