Vnet question if I may.
I setup a vnet (10.0.0.0/16) and subnetted it (10.0.1.0/24, 10.0.2.0/24, & 10.0.3.0/24)
I added a Azure SQL Database (PaaS).
The Vnet has a Service Endpoint for Microsoft.SQL (port 1433) and ASDb's server has a rule connecting the Service Endpoint to the 10.0.2.0/24 subnet.
But how do I setup a client application in either subnet 10.0.2.0/24 or 10.0.3.0/24 to point to and connect over the 10.0.2.0 Service Endpoint?
At no time do I actually know the SQL Server's 10.0.2.? 1433 listener IP address actual and given PaaS the server's DNS name is (bla....windows.net) is always going to be the internet public IP address.