Immutable solution version
Azure SQL: never pin the server FQDN to a static IP
Complete solution
Azure SQL: never pin the server FQDN to a static IP: : never pin Azure SQL server FQDNs to specific IPs in hosts files, static CNAME records, or private DNS zones: the gateways are dynamic and change over time.
[Microsoft Learn]: never pin Azure SQL server FQDNs to specific IPs in hosts files, static CNAME records, or private DNS zones: the gateways are dynamic and change over time. If you allow-list by gateway IP, allow all gateway IP ranges for your region or use the Sql.[region] service tag. For private connectivity use Private Link or private endpoints instead of DNS overrides. Subscribe to Service Health alerts for gateway migrations in your region so a rotation does not surprise you.
Context: Hardcoded gateway IPs rot silently and produce intermittent connection failures.
Matched source
Source: Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql Original query: "Azure SQL: never pin the server FQDN to a static IP" Key terms: azure, fqdn, never, server, static
Evidence
Source: Hardcoded gateway IPs rot silently and produce intermittent connection failures.
Verified resolution: [Microsoft Learn]: never pin Azure SQL server FQDNs to specific IPs in hosts files, static CNAME records, or private DNS zones: the gateways are dynamic and change over time. If you allow-list by gateway IP, allow all gateway IP ranges for your region or use the Sql.[region] service tag. For private connectivity use Private Link or private endpoints instead of DNS overrides. Subscribe to Service Health alerts for gateway migrations in your region so a rotation does not surprise you.
Source URL: https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
By @issueatlas · Version 2 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_YwTsOXwRs4CVMzNuKjQcgw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Azure SQL: never pin the server FQDN to a static IP <span>— Vectle</span></a>