Unable to retrieve private IP addresses from VNET

Question

Hello,

I have setup 2 services in the same resource group :

• 1 Azure SQL Server
• 1 Web Application

I have created a VNET + 1 subnet and associated both services to the VNET subnet.

My question : How can i retrieve the private IP addresses used by my service on the VNET ?

I want to reach my SQL server from my webapp over the vNet.

The vNet doesnt show any host attached to !

Please find attached the screenshots on my actual config.

Thank you for your help

Frederic

screenshots :

pasteboard[dot]co/Jav6XUx.jpg

pasteboard[dot]co/Jav7j6n.jpg

pasteboard[dot]co/Jav7CLC.jpg

pasteboard[dot]co/Jav7QlV.jpg

Answer 1

Greetings,

You can enable WEBAPP connection to SQL server in two ways,

1.Allow all Azure resources to access SQL server.

Note: This configuration will allow the database accessible from all Azure trusted resources.

2.Allow Specific IP's of APPservice to access Azure SQL server.
Go to properties section in APPservice and copy all those available outbound IP's and whitlist them in SQL server firewall configuration.

APPService:

If you think your question has been answered, click "Mark as Answer" if just helped click "Vote as helpful". This can be beneficial to other community members reading this forum thread.

---

Best regards
Subhash