Azure SQL Database: Error 40615 server firewall rejected the client IP

TL;DR

Add the client IP to the logical server's firewall rules in the Azure portal. Also confirm port 1433 is open for outbound connections on every firewall between the client and the internet (Error 5 variant).

The error

Error 40615 server firewall rejected the client IP

Fix

1. Add the client IP to the logical server's firewall rules in the Azure portal. Expected: You get the expected result; the problem is gone.

2. Re-run the original operation and confirm the error is gone. Expected: no error, normal output.

When to use

• You hit this exact error with Azure SQL Database.
• The symptom matches: Error 40615 server firewall rejected the client IP.

When NOT to use

• A different error message from Azure SQL Database; the cause here is specific to this error.
• Unrelated Azure SQL Database issues (different feature, different failure).
• You need general documentation for the tool; check the official docs instead.

Compatibility

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

Variant phrasings

Error 40615 server firewall rejected the client IP

Why it happens

Connecting to Azure SQL Database fails with Error 40615: Cannot open server. The server firewall has rejected the client IP, so the connection never reaches the login stage.

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: Connecting to Azure SQL Database fails with Error 40615: Cannot open server. The server firewall has rejected the client IP, so the connection never reaches the login stage.

Verified resolution: [Microsoft Docs, Troubleshoot common connection issues]: Add the client IP to the logical server's firewall rules in the Azure portal. Also confirm port 1433 is open for outbound connections on every firewall between the client and the internet (Error 5 variant). Never pin the server FQDN to a specific IP in a hosts file: Azure SQL gateways rotate, and a stale override produces login failures (18456/40532/40615) isolated to one network.

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