MS sql server

RouterOS General
1

Please i have the MS Sql Server running on a computer 192.168.88.9 behind mikrotik which mikrotik is the 192.168.1.2 of the dsl modem router. And the mikrotik is running a hotspot service with my own computers added in the “ip binding” list

the MS Sql server listens and works on the port 1433 for sure (because before the mikrotik it was working perfect)
so in the mikrotik i run the

/ip firewall nat add chain=dstnat dst-address=“192.168.1.2” dst-port=1433 protocol=tcp action=dst-nat to-addresses=“192.168.88.9” to-ports=1433
and
in the dsl modem router i forwarded the external port 1982(an example i put) to the internal 1433 and the ip 192.168.1.2
but the client computers from outside (wan) cannot connect to the MS Sql Server through sql server authentication. If i remove the mikrotik, they work perfect
Do you have any experience please on that?

2

Are you also SRC NATing / Masquerading the traffic from the SQL server as it flows out if the routerboard and towards the ADSL modem?

3

Thank you very much for the reply Celtic Communications, i will check that and i will write again please

4

Celtik and other people please in order to do this that you said above is this command okay to run?
/ip firewall nat add chain=srcnat dst-address=“192.168.1.2” dst-port=1433 protocol=tcp action=src-nat to-addresses=“192.168.88.9” to-ports=1433

Yours faithfully

5

As a starting point I suggest that you add a NAT rule which simply has action=masquerade on traffic leaving the interface which connects to the ADSL modem (specify the out-interface). You can narrow it down once you get the basics running.

6

the fastest solution i saw was to put other APs for the public users and other for the computers of the company because i saw there were many other problems. of course mikrotik is very very powerful but for me it was a little difficult due to the lack of time also,thank you for everything though