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 the Azure SQL Server administrator must not contain special characters, such as double quotes (") and back slashes (\).

Procedure

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

   The Overview page appears.

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

   The Vendor page appears.

3. Select Microsoft Azure, and then click Next.

   The Select a Database Service page appears.

4. Select Azure SQL and Managed SQL, and then click Next.

   The Plan page appears.

5. If you already have a server plan, select it. Otherwise, create a new plan.

6. Click Next. The Add cloud account page appears.

7. If you already have an existing cloud account, from the Cloud account list, select the account. Otherwise, add a new cloud account.

8. Click Next. The Instance Details page appears.

9. From the Instance name list, select the Azure SQL instance.

10. From the SQL server authentication list, select the credentials for the Azure Server admin account.

    By default, this account is the instance server admin account that has access to the instance and database to perform all operations, including backup, restore, and browse operations.

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

    Steps to add a credential

    1. Click +. The Add credential dialog box appears.

    2. In the Credential name box, enter a name for the credential.

    3. In User account, enter the user name of the Azure Server admin account.

    4. In the Password box, enter the password for theAzure Server admin account.

    5. In the Description box, enter a brief description.

    6. Click Save.

11. In the Specify storage connection string box, enter the string to access the data within the Azure storage account.

    Tip

    To get the connection string for your storage account, in the Azure portal, go to the storage account, and then go to Security + networking > Access keys.

12. Click Next.

    The Backup Content page appears.

13. All the Azure SQL instances will be backed up automatically. Click Next. The Summary page appears.

14. Click Finish.

Related Topics

Setting up Managed Identity Authentication for Azure Resource Manager