Connect to a SQL Server virtual machine on Azure from local laptop via Azure VPN client

Question

I can see that you connect to the SQL server on VM over the internet publicly (see link). However, my database contains sensitive data and I was wondering if I can set my SQL connectivity to be private (within virtual network) and then connect to the database from my local laptop via Azure VPN client.

Answer 1

Setup Firewall rules to allow access only from your machine, see

Azure SQL Database and Azure Synapse IP firewall rules

Answer 2

Hi @Jack Wong

Have you tried “Azure SQL server using an Azure Private Endpoint” It would enable Azure resources, like virtual machines (VMs), to privately and securely communicate with Private Link resources such as Azure SQL server.

Here is a document for reference - https://learn.microsoft.com/en-us/azure/private-link/tutorial-private-endpoint-sql-portal

And here is a blog post to troubleshoot any issues you may encounter during configuration

https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Thank you!