Connect to Azure SQL Managed Instance from on-premises
Learn how to set up point-to-site VPN connection to your Azure SQL Managed Instance by configuring a VPN Gateway to your Virtual Network using certificate based authentication.
Video by Rob Horrocks.
Chapters:
00:00 Introduction
00:19 Failed attempt to connect to SQL MI
01:03 Virtual Network Settings
02:00 Create Gateway Subnet
02:37 Create Virtual Network Gateway
04:08 Start configuring Virtual Network Gateway for Point-to-site
05:18 Create Root and Client Certificates using Powershell
06:28 Export Certificates from User Certificate Store
08:02 Complete Virtual Network Gateway configuration with Root Certificate details
08:46 Download and Install VPN Client
09:35 Connect to Virtual Network via VPN
10:02 Successful attempt to connect to SQL MI
🍿 Watch next | MI link to the new Next-gen General Purpose • Next-gen General Purpose impact on Azure S...
📚 Read next | New Next-gen General Purpose service tier https://aka.ms/sqlmi-nextgp
📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
Recommended content:
What is Azure SQL Managed Instance? https://learn.microsoft.com/en-gb/azu...
What is Azure Virtual Network? https://learn.microsoft.com/en-us/azu...
What is Azure VPN Gateway? https://learn.microsoft.com/en-us/azu...
Create and manage a VPN gateway https://learn.microsoft.com/en-us/azu...
Quickstart: Configure a point-to-site connection to Azure SQL Managed Instance from on-premises https://learn.microsoft.com/en-us/azu...