Configuring an Azure SQL Instance

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

Before You Begin

• Log on to the Microsoft Azure portal using your Administrator login credentials.

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

Procedure

1. From the CommCell Browser, go to Client Computers > client.

2. Right-click the SQL Server, and then click Properties.

   The SQL Server Properties dialog box appears.

3. On the Cloud Configuration tab, 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.

   2. From the Azure SQL Server Account list, select the credential for the Azure SQL server account.

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

      Tip

      To add a new credential, from the Azure SQL Server Account list, click Create New.

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

   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. You can provide the AD account credentials in the SQL Agent Authentication tab at the agent level or in the Accounts tab at the instance level. The AD account credentials are honored only when the server admin is not set at both the agent and instance levels.

   • Active directory multi-factor authentication is not supported.

4. Click OK.

5. To the SQL server, add the Azure instance that you want to protect. Verify that the name of the instance that you are adding matches the instance name on the Azure cloud.

   For instructions about adding a new instance to a SQL server, see Manually Discovering SQL Instances.

What to Do Next

Creating an Azure SQL Database Subclient