Skip to content
← Back to activity

Immutable solution version

Azure SQL: never pin the server FQDN to a static IP

Version 2Sign in to save

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>