How to send requests to the site instead of the IP address of the SQL server?

Question

SQL Server

There is a desktop program that sends sql queries to a remote server.
The server address is hardwired into the program.
But the server is spinning today on a local machine, tomorrow on a virtual one in a hosting, the day after tomorrow it moves somewhere else ...
Accordingly, the server address will change, the program will not be able to connect.
There was an idea to register a site that will be registered in the program, and the site itself will redirect requests to the actual server.
How is it possible to implement it? What technologies are responsible for this?
The question is fundamentally new to me, I do not know how to approach it.

Solution - domain binding and DNS A-record on VPS hosting

Answer 1

what you call "registering a site" is called creating an A record in your domain.

Answer 2

KMK more correctly add the ability to change the server address in the program settings.
And so, there are solutions. Google sql proxy server.

Answer 3

MS SQL has such a thing as MS SQL Browser. This is a standard service that comes bundled with ms sql, it deals with the resolution of queries going to different instances of ms sql on the same machine. Perhaps she knows how to do this for ms sql located not on the same machine.
In general, you can use any software that can redirect ports. MS SQL uses 1 TCP port.
But here the question is, is it worth exposing the MS SQL port to the Internet? A bunch of coolhackers will immediately rush there trying to break it. I would not do this, if it is very necessary, then only through VPN.