How to give an Azure SQL DB instance a private IP?

Question

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?

score 3 · Accepted Answer · answered Oct 08 '19 at 19:58

3

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

answered Oct 08 '19 at 19:58

JohnW

501

score 2 · Answer 2 · answered Feb 08 '18 at 11:17

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.

How to give an Azure SQL DB instance a private IP?

2 Answers2