Azure SQL DB service endpoint

Question

Hello team,

I hope you're doing fine,

I have a question, let's assume i have an azure sql db connected to a public endpoint.
And i have Azure VMs that are accessing this DB using Internet
Now let's assume i want my azure VM to access this same DB but using the azure private backbone network.

So for this i enabled service endpoint on the subnet of the VMs, and allow the virtual network on the sql server hosting the azure DB.
Let's assume at this level, both public access and service endpoint are enabled at the same time for the VMs.

By default when the VMs, will try to access the DB, they will use the private network? service endpoint will take priority over the internet access to the VM?
and let's assume there is an issue with the private access, will it failover to the internet one?

Thank you

Answer 1

Hello @Mohamed jihad bayali !

In this scenario, the VMs will prioritize the private network access through the service endpoint over the internet access. The traffic from the VMs to the Azure SQL DB will be routed through the Azure backbone network, which provides a more secure and reliable connection compared to internet-based access.

However if there is an issue , it wont redirect

You need manually to disable the service endpoint on the subnet of the VMs

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

that's what i thought
Thanks