Adding an Azure SQL Managed Instance


You can add an Azure SQL managed instance so that you can back up its databases.

Before You Begin

The password for Azure SQL Server administrator must not contain special characters, such as double quotes (") and back slash (\).


  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the Add instance button, and then select Cloud db service.

    The Add Cloud DB instance dialog box appears.

  3. From the Select vendor list, select Microsoft Azure.

  4. From the Database service list, select SQL server.

  5. From the Cloud account list, select the Azure cloud account.

    You can select an existing Azure account for the instance, or define a new Azure account.

    To create a new Azure account, complete the following steps:

    1. Click +.

      The Add cloud account page appears.

    2. In the Name box, type a name for the new cloud account.

    3. In the Subscription ID box, enter the subscription ID for the Azure cloud account.

      For instructions about accessing this information from the Azure portal, see SQL Server Azure Cloud Connection Properties.

    4. To connect to the Azure account without using managed identities, move the Connect using managed identities for Azure resources toggle key to the left, from the Credentials list, select the credential for the Azure cloud account.

      For information about connecting the Azure account using managed identities, see Setting up Managed Identities for Azure Resources.

    5. From the Access nodes list, select the proxy servers.

      The operating system of the access node can be either Windows or Red Hat Enterprise Linux.You can add multiple proxy servers to the app. The Commvault software uses the first proxy server in the list for instance and database discovery.

    6. To specify the connection information for the Azure cloud, under Connection details, do the following:

      1. In the Storage connection string box, enter the string to access data within the Azure storage account.

        Tip: To get the connection string for your storage account, in the Azure portal, go to Settings > Access keys.

        If the access node has Commvault software that is deployed using the Feature Release 28 or a more recent version and you want to import and export an Azure SQL database to a BACPAC file larger than 200 GB, in the Staging path used for import/export box, enter the staging path available on the access node.

        Note: For Azure SQL managed instance, Commvault does not support staging path.

      2. From the SQL server authentication list, select the credential for the SQL server account.

        The user account is the server administrator for the Azure SQL DB instances that you are adding.

        Tip: To create a new credential, beside the SQL server authentication list, click Create new.

    7. Click Save.

  6. From the Plan list, select the server plan to use for the managed instance.

  7. From the Instance name list, select the SQL instance.

  8. To specify the connection information for Azure cloud instance, under Connection details, specify the connection string for Azure storage account and credential for the SQL server account.


    • To use an Active Directory (AD) account for the backup, install the Microsoft Active Directory Authentication Library for Microsoft SQL Server on the access node and configure an Active Directory admin for that instance on the Azure portal. The AD account must be the Azure AD administrator or a member of the AD group assigned to the Azure SQL instance. To provide the AD account credentials, edit the SQL cloud configuration setting in the Configuration tab for the SQL instance and provide the AD account credentials in the SQL server authentication box.

    • Active Directory authentication does not work for Azure SQL databases that are protected using a Linux access node.

  9. Click Add.

Setting up Managed Identity Authentication for Azure Resource Manager