Determine the management endpoint IP address - Azure SQL Managed Instance

Je li ova stranica od pomoći?

Imate dodatne povratne informacije?

Povratne informacije će biti poslane kompaniji Microsoft: pritiskom na dugme za slanje, vaše povratne informacije će se koristiti za unapređivanje proizvoda i usluga kompanije Microsoft. Pravila privatnosti.

APPLIES TO: Azure SQL Managed Instance

The Azure SQL Managed Instance virtual cluster contains a management endpoint that Azure uses for management operations. The management endpoint is protected with a built-in firewall on the network level and mutual certificate verification on the application level. You can determine the IP address of the management endpoint, but you can't access this endpoint.

To determine the management IP address, do a DNS lookup on your SQL Managed Instance FQDN: mi-name.zone_id.database.windows.net. This will return a DNS entry that's like trx.region-a.worker.vnet.database.windows.net. You can then do a DNS lookup on this FQDN with ".vnet" removed. This will return the management IP address.

This PowerShell code will do it all for you if you replace <MI FQDN> with the DNS entry of SQL Managed Instance: mi-name.zone_id.database.windows.net:

  $MIFQDN = "<MI FQDN>"
  resolve-dnsname $MIFQDN | select -first 1  | %{ resolve-dnsname $_.NameHost.Replace(".vnet","")}

For more information about SQL Managed Instance and connectivity, see Azure SQL Managed Instance connectivity architecture.