if i create dns static entry like
/ip dns static add name=sql address=10.77.0.4
https://lh3.googleusercontent.com/-uQ1GCbVl270/Vm1IKgot7BI/AAAAAAAABo0/ozUWMMOfXA4/s0/screenshot%2525202015-12-13%252520004.jpg
It do not work
https://lh3.googleusercontent.com/-OdAbj-xWStA/Vm1KJ2O5GwI/AAAAAAAABpA/XfDCmrHdmW0/s0/screenshot%2525202015-12-13%252520005.jpg
If I create dns static entry like
/ip dns static add name=sql.ramteks.local address=10.77.0.4
https://lh3.googleusercontent.com/-f-kygj5v_yg/Vm1IBrEfhxI/AAAAAAAABos/YkzfnEeswmM/s0/screenshot%2525202015-12-13%252520003.jpg
Then all is ok.
https://lh3.googleusercontent.com/-_1dn-YQZFdM/Vm1MKMaDU4I/AAAAAAAABpM/fliJ154k-eU/s0/screenshot%2525202015-12-13%252520006.jpg
Why do not work first case?
Why do not work first case - case without dot in host name?
I have tested this on my router [RB951, 6.33.3] and it works as expected. Try testing from a different client or use a packet capture to see what query the client is really sending.
It’s client problem. Even though you ask nslookup for “sql”, what it actually sends to resolver is “sql.”. You would have to use “sql.” (with trailing dot). Or set sql.ramteks.local on router and then using “sql” on client should give you proper address, but only if client thinks it’s part of ramteks.local.