Quickstart: Create an Azure SQL Database Managed Instance

This quickstart walks through how to create an Azure SQL Database Managed Instance in the Azure portal.

If you don't have an Azure subscription, create a free account before you begin.

Sign in to the Azure portal

Sign in to the Azure portal.

Create a Managed Instance

The following steps show you how to create a Managed Instance.

  1. Choose Create a resource in the upper left-hand corner of the Azure portal.
  2. Locate Managed Instance and then select Azure SQL Managed Instance.
  3. Select Create.

    Create managed instance

  4. Fill out the Managed Instance form with the requested information, using the information in the following table:

    Setting Suggested value Description 
    Subscription Your subscription A subscription in which you have permission to create new resources
    Managed instance name Any valid name For valid names, see Naming rules and restrictions.
    Managed instance admin login Any valid user name For valid names, see Naming rules and restrictions. Don't use "serveradmin" as that is a reserved server-level role.
    Password Any valid password The password must be at least 16 characters long and meet the defined complexity requirements.
    Location The location in which you want to create the Managed Instance For information about regions, see Azure Regions.
    Virtual network Select either Create new virtual network or a virtual network that you previously created in the resource group that you previously provided in this form. To configure a virtual network for a Managed Instance with custom settings, see Configure SQL Managed Instance virtual network environment template in Github. For information regarding the requirements for configuring the network environment for a Managed Instance, see Configure a VNet for Azure SQL Database Managed Instance.
    Resource group A new or existing resource group For valid resource group names, see Naming rules and restrictions.

    managed instance form

  5. To use the Managed Instance as an Instance Failover Group secondary, select the checkout and specify the DnsAzurePartner managed instance. This feature is in preview and not shown in the accompanying screenshot.

  6. Select Pricing tier to size compute and storage resources as well as review the pricing tier options. The General Purpose pricing tier with 32 GB of memory and 16 vCores is the default value.
  7. Use the sliders or text boxes to specify the amount of storage and the number of virtual cores.
  8. When complete, choose Apply to save your selection.
  9. Select Create to deploy the Managed Instance.
  10. Select the Notifications icon to view the status of deployment.

    managed instance deployment progress

  11. Select Deployment in progress to open the Managed Instance window to further monitor the deployment progress.

Important

For the first instance in a subnet, deployment time is typically much longer than in subsequent instances. Don't cancel the deployment operation because it lasts longer than you expected. Creating the second Managed Instance in the subnet only takes a couple of minutes.

Review resources and retrieve your fully qualified server name

After the deployment completes successfully, review the resources created and retrieve the fully qualified server name for use in later quickstarts.

  1. Open the resource group for your Managed Instance and view its resources that were created for you in the Create a Managed Instance quickstart.

  2. Select your Managed Instance.

    Managed Instance resources

  3. On the Overview tab, locate the Host property and copy the fully qualified host address for the Managed Instance.

    Managed Instance resources

    The name is similar to your_machine_name.a1b2c3d4e5f6.database.windows.net.

Next steps