azure sql server access from VM with different Virtual Network

Question

Hi,

I have SQL DB locked down to be able to connect through private endpoint and have a VM created in different virtual network. I do have private endpoint created to in the Vnet where the VM is hosted but still not able to connect to the database from the vm. I do have access to the database. Port is also open for inbound traffic. Can some help me please?

Answer 1

Issue Description : You are trying to access Azure SQL server from a VM created in different Virtual network

Recommendations:

-One of the reason as seen in previous cases is that the internal load balancer was configured using basic version. After creating a load balancer with Standard version, cx was able to connect. I was able to reproduce this on my side as well. Please try this and let me know if that was the case with you.

Reference doc : https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-vnn-azure-load-balancer-configure#create-load-balancer

-Please refer to this document with details on how to Connect to SQL Server within a virtual network and see if you are missing any step.

Let me know if you are still seeing issue after going through the above suggestions and I can investigate further. Thanks.