Connect to Azure SQL from Azure point to site Vpn client

Question

How do I connect to my sql server via Azure VPN client?

Answer 1

Hi @Olufemi Oyekanmi

Configure a point-to-site connection to Azure SQL Managed Instance from on-premises
Azure SQL Managed Instance using SQL Server Management Studio (SSMS) from an on-premises client computer over a point-to-site connection.
On the on-premises client computer, open SQL Server Management Studio.

SQL Database creates a firewall at the server level for single and pooled databases. This firewall prevents client applications from connecting to the server or any of its databases unless you create an IP firewall rule to open the firewall. For a connection from an IP address outside Azure, create a firewall rule for a specific IP address or range of addresses that you want to be able to connect from.
https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-create-server-level-portal-quickstart

Azure SQL database is public over the Internet, however, the traffic through a VPN connection from your on-premise network is private so it does not support to access Azure SQL database over VPN.

refer- https://stackoverflow.com/questions/57376952/connect-to-azure-sql-over-vpn

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

Answer 2

Hi OlufemiOyekanmi-2266,
As learn2skills mentioned, it is not supported to connect to Azure SQL via Azure VPN client currently.
But here are workarounds which might help:

This means that we either need to create our own workarounds, such as SSH tunnels via VMs inside Azure, or we need to keep using the IP whitelisting method (the latter of which defeats the whole purpose of using a VNET-based access control).

Please refer to:
https://feedback.azure.com/forums/217321-sql-database/suggestions/34658080-allow-elasticpool-sql-database-to-join-p2s-virtual

https://techcommunity.microsoft.com/t5/azure-sql/connect-to-azure-sql-database-with-point-to-site-connection-and/m-p/1362840
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.