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. Click 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. Click 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. Do not 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.
    Resource Group A new or existing resource group For valid resource group names, see Naming rules and restrictions.
    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

    managed instance form

  5. Click 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.

  6. Use the sliders or text boxes to specify the amount of storage and the number of virtual cores.
  7. When complete, click Apply to save your selection.
  8. Click Create to deploy the Managed Instance.
  9. Click the Notifications icon to view the status of deployment.

    managed instance deployment progress

  10. Click 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 case of the subsequent instances. Do not cancel 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.

    Managed Instance resourcesOpen your Managed Instance resource in the Azure portal.

  2. Click your Managed Instance.

  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 this: your_machine_name.neu15011648751ff.database.windows.net.

Next steps