Forum Discussion

iamshe385's avatar
iamshe385
Copper Contributor
Oct 23, 2023

Azure SQL VPN connection

Hello! 

 

I have been tasked with setting up an SQL database in Azure. There are several people who are supposed to be abole to reach the database thorugh SMSS. I know that one can add ones client !P-adress but adding every IP-adress every person uses is very hard (Theres no static IP-adress so a new one has to be added everytime). I am therefore wondering if there are any suggestions on how to fix this. Can i add a Virtual gateway directly the VNET? 
 I want to keep the setup as simple as possible. Theres no VM only the SQL database + server. 

2 Replies

  • JeremyWallace's avatar
    JeremyWallace
    Brass Contributor
    Oct 30, 2023
    Yes instead of doing public access to the Azure SQL database and opening up via IP you could connect the database to an Azure virtual network via Azure Private Endpoint (https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview) and then either setup an azure virtual network gateway for you to VPN to in order to access the database over private network, or you could setup a small Azure Virtual Desktop (AVD) host (https://www.linkedin.com/pulse/what-azure-virtual-desktop-revolutionize-your-business-jeremy-wallace) with SSMS on it that you can publish out to people as a remote app that they can either access via the remote client or in a browser (https://learn.microsoft.com/en-us/azure/virtual-desktop/manage-app-groups) and not have to deal with VPN.

Resources