DST NAT 2 WAN 2 LAN

Hello,

I have this schema.

ether1 => WAN1
ether2 => Wan2

Ether3 => LAN1
Ether4 => LAN2

Everthing is working well, internet browsing according to routing marks is ok.

The thing is, I have a SQL server over LAN2, Manager used to move over LAN1 and LAN2, some times he want to connect to SQL using WAN1 IP Address, so, How can I get this working?

lets say LAN2 PC is 172.16.0.10 trying to get 1.1.1.1 WAN1 Public IP address on port 1433, but as routing marks he’s always going out trough WAN2.

Thank you in advance…

This is typical load balancing setup, you can find many on manual. For example:
http://wiki.mikrotik.com/wiki/PCC#Application_Example_-_Load_Balancing