We have an Azure SQL database with no public access and a private endpoint. In our small data movement network we use azure dns, and thus pick up the IP via the private zone created.
However, we have another subnet which does not use azure DNS, and the owners of this network do not want to add in the dns records for the private endpoint.
I understand that Azure SQL is behind a load balancer, hence it needs to know what actual "server" you are connecting to.
Is there a way (in SSMS or otherwise) to connect via IP but also pass along the "name" it wants to connect to? Kind of like a host header in http?
The only alternative is a hosts file, which really is not a great solution.
Thanks
