Configuring an Azure SQL Instance

You must add the SQL instance that you want to protect to a SQL server.

Before You Begin

• To add a managed instance, you must be logged on to the Azure portal as an administrator.

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

Procedure

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

   The Instances page appears.

2. Click Add instance.

   The Add instance dialog box appears.

3. Click Cloud DB.

   The Add Cloud DB instance dialog box appears.

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

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

6. Assign an Azure 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 Add.

      The Add cloud account page appears.

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

   3. To connect to the Azure account using managed identities, move the Connect using managed identities for Azure resources toggle key to the right.

      For more information about setting up managed identities for Azure, see Setting up Managed Identity Authentication for Azure Resource Manager.

   4. In the Subscription ID, Tenant ID, Application ID, and Application password boxes, enter the details that you need to access data on the Azure cloud.

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

      Note

      If you enabled Azure managed identities authentication, you need only the Subscription ID, not the Tenant ID, the Application ID, or the Application Password.

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

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

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

8. From the SQL Server instance list, select the instance.

9. Under Connection details section, enter the following information:

   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.

   2. In the User name, Password, and Confirm password boxes, enter the credentials of a Windows user account that has permission to perform all operations, including backup, restore, and browse.

      Note

      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 General settings for the SQL Server instance and provide the AD account credentials under the SQL server authentication group.

10. Click Add.