Connect to Azure SQL Managed Instance from on-premises

Channel Avatar
Comment
X
Share
Connect to Azure SQL Managed Instance from on-premises
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 configurin a VPN Gateway to your Virtual Network using certificate based authentication. 

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 

Recommended content:
What is Azure SQL Managed Instance? https://learn.microsoft.com/en-gb/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?viewazuresql
What is Azure Virtual Network? https://learn.microsoft.com/en-us/azure/virtual-network/virtual-networks-overview
What is Azure VPN Gateway? https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-about-vpngateways
Create and manage a VPN gateway https://learn.microsoft.com/en-us/azure/vpn-gateway/tutorial-create-gateway-portal
Quickstart: Configure a point-to-site connection to Azure SQL Managed Instance from on-premises https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?viewazuresql

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *