I have an Azure SQL Server that I would like to access from 2 different VNET's. I can create Private Endpoints to both VNET's, but how about the name resolution?
In here https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-dns I see the following:
Existing Private DNS Zones tied to a single service should not be associated with two different Private Endpoints as it will not be possible to properly resolve two different A-Records that point to the same service. However, Private DNS Zones tied to multiple services would not face this resolution constraint.
So how would I enable name resolution to Azure SQL from both VNET's? Thanks for any replies!