Azure SQL error 40615: the client IP is not in the firewall rules

TL;DR

Error 40615 'Cannot open server' means the client IP is not allowed by the server firewall: configure firewall settings on SQL Database through the Azure portal. If login failures (18456, 40532, 40615) hit only specific client networks, suspect a hosts file or static CNAME pinning the server FQDN to a retired gateway IP: remove the override, flush DNS, and re-test. Error 5 with 'Cannot connect' means port 1433 is closed for outbound connections on a firewall between the client and the internet: open it.

Fix

1. Error 40615 'Cannot open server' means the client IP is not allowed by the server firewall: configure firewall settings on SQL Database through the Azure portal. Expected: You get the expected result; the problem is gone.

2. If login failures (18456, 40532, 40615) hit only specific client networks, suspect a hosts file or static CNAME pinning the server FQDN to a retired gateway IP: remove the override, flush DNS, and re-test. Expected: You get the expected result; the problem is gone.

When to use

• You are setting up or using this Azure SQL error 40615 feature.
• The symptom matches: the client IP is not in the firewall rules.

When NOT to use

• Unrelated Azure SQL error 40615 issues (different feature, different failure).
• You need general documentation for the tool; check the official docs instead.

Compatibility

Reported against Azure SQL error 40615. Source: https://github.com/microsoftdocs/sql-docs/blob/HEAD/azure-sql/database/troubleshoot-common-errors-issues.md.

Variant phrasings

the client IP is not in the firewall rules

Why it happens

40615 always means the firewall blocked the client. Fix the rule, not the connection string.

Edge cases

• If your error message differs even slightly, this is probably a different issue; search the exact text.
• If the fix does not help, capture the full error output and check the source link for updates.

Source

https://github.com/microsoftdocs/sql-docs/blob/HEAD/azure-sql/database/troubleshoot-common-errors-issues.md

Source: 40615 always means the firewall blocked the client. Fix the rule, not the connection string.

Verified resolution: [Microsoft SQL docs]: Error 40615 'Cannot open server' means the client IP is not allowed by the server firewall: configure firewall settings on SQL Database through the Azure portal. Error 5 with 'Cannot connect' means port 1433 is closed for outbound connections on a firewall between the client and the internet: open it. If login failures (18456, 40532, 40615) hit only specific client networks, suspect a hosts file or static CNAME pinning the server FQDN to a retired gateway IP: remove the override, flush DNS, and re-test.

Source URL: https://github.com/microsoftdocs/sql-docs/blob/HEAD/azure-sql/database/troubleshoot-common-errors-issues.md