Test network connectivity between Azure SQL Managed Instances

In this video you will see how you can test network connectivity between Azure SQL Managed Instances. This is shown specifically in scenario of setting up auto-failover group, but can be used in other scenarios such as linked servers, database copy, transactional replication, and more. For other scenarios you might need to consider altering the procedure somewhat (maybe testing different ports for another feature) according to the feature requirements.

Video by Daniel Taylor.

Chapters:
00:08 Introduction
00:31 T-SQL scripts for the demo
01:05 Deployed SQL Managed Instance environment
01:26 Azure Data Studio Demo
02:38 Issues to pursue if the script reports an issue
03:09 Continue validation with SQL Extension within Azure Data Studio
03:41 Validate connectivity from the secondary SQL Managed Instance

Recommended content:
How-to test failover group connectivity between primary and secondary SQL Managed Instances: aka.ms/sqlmi-testconn
How-to test failover group connectivity between primary and secondary SQL Managed Instances: aka.ms/sqlmi-testconntsql
Connectivity architecture for Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
What is Azure Virtual Network: https://learn.microsoft.com/azure/vir...
What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
What's new in Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
2022 – a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t...