Simple static routing and SQL Server

[rcngc]

Whne they connected to the same switch, it will use broadcast as part of the name resolution process and will work as they are on same layer2 network.

No broadcasting crosses layer 3 networking (routing), so to resolve this, you will need to enter name / IP details statically in Mikrotik DNS

Thanks for your answer. Following your advice I found another post regarding the use of Mikrotik DNS to resolve hostnames, answered by ZeroByte

http://forum.mikrotik.com/t/how-to-set-hostname-for-a-specific-static-ip/102749/1

Whatever that is, you can create host names in the Mikrotik’s DNS proxy:
/ip dns static add address=192.168.10.14 name=myhost.example.com

Then you need to either assign the Mikrotik as the LAN’s DNS server address, or else use a dstnat rule to intercept (redirect) outbound DNS queries to the Mikrotik itself:
/ip firewall nat add chain=dstnat protocol=tcp dst-port=53 action=redirect
/ip firewall nat add chain=dstnat protocol=udp dst-port=53 action=redirect

And make sure sure that your DNS service allows remote requests:
/ip dns set allow-remote-requests=yes

AND MOST IMPORTANTLY:
Make sure that your firewall filter’s input chain will drop incoming requests to port 53 from the Internet

I’ll do as described