question

OlufemiOyekanmi-2266 avatar image
0 Votes"
OlufemiOyekanmi-2266 asked AmeliaGu-msft commented

Connect to Azure SQL from Azure point to site Vpn client

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

sql-server-generalazure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered learn2skills edited

Hi @OlufemiOyekanmi-2266

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.

88021-image.png

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.



image.png (79.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.