@JohnC92 ,
Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
For your requirement, the App Service should be VNET Integrated and the SQL DB should have a Private EndPoint in the same VNET or a VNET that is peered to the VNET where the App Service is integrated.
To check if the traffic from App Service to the SQL DB is going via Public or PE (private),
- You can use Kudu service from App Service.
- From the Kudu Console, do a
nslookup <FQDNofSqlDb>
- If this resolves to the Public IP - connection is going via Internet
- If this resolves to the Private IP of the Private EndPoint - this means traffic is restricted to the virtual network only.
Hope this makes it clear.
Cheers,
Kapil