This document provides in-depth configuration of Azure App-Service with Azure SQL (Private Link)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/private-web-application-app-service-private-sql-1-2.jpg)
- Create a New Resource Groups for App-Service & Azure SQL
- Create an App-Service(SQU: dotnet 6 LTS) with App-Service Plan
- Search and Create Azure SQL
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-81.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-117.png)
- Create Azure SQL Database Server
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-83.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-85.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-86.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-88.png)
- Create Azure SQL Database
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-89.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-90.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-91.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-92.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-93-739x1024.png)
- Create Virtual Network
- Create New Resource Group for Virtual Network
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-94.png)
- Create two subnets for application & database
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-95.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-96.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-97.png)
- Creating a Private Link Endpoint on Azure SQL Server
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-98.png)
- Select the Azure Sql Resource Group
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-99.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-100.png)
- Select Database Subnet
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-101.png)
- Select Azure Sql Resource Group
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-102.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-103.png)
- Interacting App-service Network – Outbound Traffic
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-104.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-105.png)
- Select App Subnet
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-106.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-107.png)
Testing Network Connection
- Create a Azure Windows Virtual Machine connection to Database Subnet
- On the Virtual Machine search for ODBC
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-108.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-109.png)
Use the Azure SQL’s Connection Sting to Connect
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-111.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-112.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-113.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-114.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-115.png)
![](https://www.azure365pro.com/wp-content/uploads/2023/03/image-116.png)