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


-----Original Message-----
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

First
Tks about your response.

But i have only one public ip, i want redirect to two internals private ips
thats it.
my diagram
                    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 )

ok
Tks


----- 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
need
> 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...
>
> 200.100.100.1 port 1433 -> 192.168.0.5 port 1433
> 200.200.200.2 port 1433 -> 192.168.0.7 port 1433
>
> with one nat redirect i did(works good), but when i add second role its
not
> work, why?
>
> so if any have one tutorial or help.
> Tks
>
>
>
>