Azure Sql server Private DNS resolving Public IP in the place of Private IP

Question

Azure Sql server Private DNS resolving Public IP in the place of Private IP

Satish B 210

Hi Team,

I have Hub & spoke architecture. in Hub we have azure private resolver with forwarding rule set & Inbound and outbound endpoint configured. I have deployed Azure Private DNS Zone(database.windows.net) & linked with all Hub & spoke Vnets. & also I have deployed Azure sql server with Private endpoint and attached with HUb Private DNS Zone. As per client in onprem DNS forwarder for database does not exist. How to handle & resolve this issue .The complete deployment done using terraform.is their any option available with creating on Prem dns forwarder for database.

Can some one pls suggest

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

TP 163.4K Volunteer Moderator

Hi Satish,

The typical way to handle this is to have DNS server(s) on premises with conditional forwarding to your Azure DNS Private Resolver. These DNS servers could run on VMs, or part of on-prem firewall device or similar.

Please see diagram below from Azure Private DNS Resolver documentation:

Screenshot of Azure DNS Private Resolver architecture showing DNS resolution flow between Azure virtual networks and on-premises networks through inbound and outbound endpoints.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

0 comments