I've set up an Azure SQL database with a private link IP address of 10.120.3.7, and I've disabled public access. I have a site-to-site VPN in place and a VM that's in the same subnet as the private link, which connects without any problems. However, I'm having trouble connecting to the database using its private link IP. Interestingly, when I enable public access, I'm able to connect using the public DNS name. I'm looking for help to understand why the connection fails when I try to use the private link IP.
3 Answers
You probably need a private DNS resolver to connect through the private link IP. Azure uses DNS for name resolution, so without proper DNS settings, the connection might not work as expected.
Keep in mind that simply using the IP might not be enough. Your connection needs to resolve the DNS name to work properly with Azure SQL. Try connecting using the DNS name instead of the IP.
Have you tried adding an entry in your host file that points the public name to the private IP? Also, consider the name resolution setup in Azure; that might make a difference in your connection.
But why is a private DNS needed just to connect via IP, isn’t that overkill?