title: Azure App Service can't access Azure SQL DB, but local machine works. Allow-All-IP rule already in place.
body: <p>Currently working on an ASP.NET web application. I would like to deploy to Azure App Service but when running on App Service, the connection to my Azure SQL server can not be found. 
  <a href="https://i.stack.imgur.com/XczGP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XczGP.png" alt="enter image description here"></a></p>
  
  <p>When I run on my local machine, the connection to the Azure SQL server works. I can also connect to my Azure SQL server via SQL Management Studio.</p>
  
  <p>On the Azure SQL server I have set up a Firewall rule to allow all IP addresses, and allowed access to Azure services:<a href="https://i.stack.imgur.com/a8wKP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a8wKP.png" alt="enter image description here"></a> </p>
  
  <p>I have done considerable searching for solutions to this problem over the past couple days, but I can't find a solution.</p>