How do I connect to my sql server via Azure VPN client?
How do I connect to my sql server via Azure VPN client?
Hi @OlufemiOyekanmi-2266,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
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://docs.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.
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.
10 people are following this question.