I am able to connect to my MS SQL Server remotely (on our VPN) when I use its IP address, but not when I use a domain name pointing to that IP address (from a DDNS service). I'm using HeidiSQL as a client.
Does SQL Server need to be configured to allow me to use the domain name instead of the IP address? (Can it tell the difference?)