How to secure access from App Service To Azure Sql Database using virtual network? : <h1>Scenario</h1>

<p>I want to use virtual network in order to limit access to Azure Database only from my App Service, so that I can turn of "Allow access to App Services" in firewall settings</p>

<p><a href="https://i.stack.imgur.com/ZLj7i.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ZLj7i.png" alt="Allow access to App Services screenshot"></a></p>

<h2>What I have done:</h2>

<ol>
<li>I went to App Service -> Networking -> VNET Integration -> Setup -> Create New Virtual Network</li>
<li>I've created new VNET with default settings.</li>
<li>When VNET was created I went to App Service -> Networking -> VNET Integration and ensured that the VNET is connected</li>
<li>I went to SQL Firewall settigs -> Virtual Network -> Add existing Virtual Newtork and selected my VNET. I've left default subnet and address space: "default / 10.0.0.0/24" and I've left IgnoreMissingServiceEndpoint flag unchecked.</li>
</ol>

<p>I can now see Microsoft.Sql service endpoint in my VNET:
<a href="https://i.stack.imgur.com/9aV9y.png" rel="noreferrer"><img src="https://i.stack.imgur.com/9aV9y.png" alt="enter image description here"></a></p>

<h1>Question</h1>

<p>However, I'm still getting </p>

<blockquote>
  <p>SqlException: Cannot open server 'my-sqlserver' requested by the
  login. Client with IP address '52.233.<strong><em>.</em></strong>' is not allowed to
  access the server.:</p>
</blockquote>

<p>What am I missing?</p>
