Connecting Web App to Azure SQL DB in Vnet

3
votes

My Web app is placed inside a Vnet as Vnet1 and subnet as Subnet1. I wanted to use Azure Sql Server V12 as a DB.

Q1: How Azure Sql Server V12 DB will be placed inside a Vnet & Subnet?

Q2: If Azure Sql Server V12 DB is placed inside a Vnet & Subnet then how this Vnet & Subnet will be connected to Vnet1 & Subnet1(of Web app)?

Thanks in advance.

2
azure
I answered, assuming you were talking about SQL Database service. If assumption this is incorrect (and instead you're using SQL Server in a VM), please clarify. – David Makogon

2 Answers

0
votes

You cannot assign a SQL Database instance to a VNet - SQL Database is DB-as-a-Service - you access it by its <yourdb>.database.windows.net endpoint name.

0
votes

I believe you are referring to service endpoints. You can configure this via the Firewall Settings for your database server instance. There you can specify a VNet access rule. In the rule, you define the Resource Group, VNet, and subnet. It will also setup the service endpoint in that subnet if one does not already exist.

Note that you can only manage FW settings on the SQL server, not the individual databases.