40615 🔷 Azure

Azure SQL: Cannot open server 'x' requested by the login. Client with IP address 'y' is not allowed to access the server (Error 40615)

The Azure SQL server firewall doesn’t allow your client’s IP address.

Seen on: Azure

Meaning

Azure SQL blocks all IPs by default. Add a firewall rule for your IP, enable “Allow Azure services” for Azure-hosted apps (or better, use private endpoints/VNet rules). Changing home/office IPs often re-trigger it.

Common causes

  • Client IP not in server firewall rules
  • App Service/Functions outbound IPs not allowed
  • Public network access disabled (private endpoint only)

⚡ Quick fix

  1. Add a firewall rule for the IP in the message
  2. Allow Azure services or add VNet rule/private endpoint for Azure apps
  3. Check Public network access setting

Detailed fix by platform

Azure CLI

  1. az sql server firewall-rule create -g rg -s sql-app -n my-ip --start-ip-address 203.0.113.7 --end-ip-address 203.0.113.7

How to diagnose

  1. IP — Address in the error
  2. Network — Public access enabled?
  3. App — Outbound IPs/VNet integration

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.