Connecting to an Azure SQL Managed Instance

Connecting to the SQL Managed Instance can be done by using SQL Server Management Studio, but only under the following conditions:

  • You are trying to connect to the server from an Azure VM that exists in the same VNet as the SQL Managed Instance.
  • You are connecting from an Azure VM that does not share the same VNet as the Managed Instance; you need to make sure that it has network connectivity to the VNet where the Managed Instance exists (via a VNet peering, for example).
  • You can connect from on-premises, but with a network connection in place between your on-premises and Azure, via one of the following options:
    • Point-to-site VPN connection
    • Site-to-site VPN connection
    • Express route

When you have achieved one of the preceding conditions, you can run SSMS and connect to the Managed Instance in the same way that you did in the previous chapter.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.147.86.154