How to give an Azure SQL DB instance a private IP?
11,307
Solution 1
As of September 2019, Microsoft now has 'private endpoints' in preview for Azure SQL DB.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-private-endpoint-overview
Solution 2
You cannot give Azure SQL Db any specific IP address. However, you can configure service endpoint of Azure SQL Db to allow any resources inside VNET or from a specific IP. It means inbound to Azure SQL Db can be controlled. It would be a hope to have User-Defined Routing to support Azure SQL Db to route traffic to ExpressRoute.
Related videos on Youtube
09 : 57
Azure Private Endpoints Simply | SQL Server Demo
17 : 35
Creating a Microsoft Azure SQL Database (SQL Server in the Cloud)
10 : 02
Private Link for Azure SQL Database - Part 1 | Data Exposed
17 : 30
How to Create Private Endpoint for Azure SQL Database and Access from VM by using SSMS
14 : 56
How to use Private Endpoint for Azure SQL Database from Azure Data Factory - ADF Tutorial 2021
Author by
Neil P
SQL Server and business intelligence developer, also dabbles in C#
Updated on September 18, 2022Comments
-
Neil P almost 2 years
I have an Azure SQL DB. Is it possible to give it a local IP address for connections from within my network and vnet so that it forces the traffic over expressroute?
-
Kevin Burandt over 6 yearsVNet Service Endpoints for Azure SQL Database now generally available azure.microsoft.com/en-us/blog/… -
EagleDev over 6 years@KevinBurandt it is inbound control only. It means with the service endpoint, you can allow inbound network traffic from subnet's service endpoint enabled to connect to Azure SQL Database.