# Add an Access Node for Azure SQL Instance

Deploy an access node to enable backup and restore operations for an Azure SQL Instance.

This procedure installs the required Commvault Cloud Apps packages on a Windows or Linux computer that functions as the access node.

## Before You Begin

You need the following information:

- Host name

- User name and password or saved credentials

- OS type

## Procedure

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

   The Databases Overview page appears.

2. In the upper-right area of the page, click Add server.

   The Configure Database Server page appears.

3. Click SQL server.

4. Click Next.

   The Install the SQL Server Package on your database server page appears.

### Choose the installation method

1. From the Add Database Server, you can install the SQL Server package on the database server that you want to protect.

   Two installation methods are available:

   - Interactive installation: Installs the SQL Server package manually on the target database server. Choose this option if you prefer to run the installation locally on the server or if push installation is not permitted in your environment.

   - Push installation: Installs the SQL Server package remotely from the Command Center to the target database server. Choose this option to deploy the package centrally without manually logging in to the database server.

Interactive installation

1. Select Interactive installation.

2. Move the toggle to the right to enable the Select Backup Gateway option. Depending on your environment, you can enable Backup Gateway to use a server that connects your data sources to the software control plane.

3. Click the package to download for the platform: Windows (64-bit) or Linux (64-bit), and copy the provided Auth code to your clipboard, as it will be required during the package installation process.

4. Run the installation on the database server and authenticate using the provided authcode.

5. After the installation is complete, refresh the page and select the newly installed server from the list.

6. Click Next.

7. From the Plan list, select a backup plan.

8. Click Next.

   The SQL server authentication dialog box appears

9. To use Use local system account, move the toggle to the right. This option runs SQL Server operations using the Windows Local System account on the client server.

10. From the Credentials list:

    - To use saved credentials, move the Use saved credentials toggle to the right, then select a credential.

    - If you are not using saved credentials, use the following steps to create a new one:

      Steps to create credentials

      1. Click the add button .

         The Add credential dialog box appears.

      2. For Account Type, select the authentication method to use for the SQL Server instance.

      3. For Credential Vault, select the credential vault to save the credentials in.

      4. In Credential name, enter a descriptive name for the credentials.

      5. In User account, enter the account that will be used for authentication.

      6. In Password, enter the password associated with the user account.

      7. In Email, enter the email address associated with the account.

      8. In Description, enter a description of the credentials.

      9. Click Save.

11. Click Next.

Push installation

1. Select Push installation.

2. Click Add to specify the database server where the SQL Server package will be remotely installed.

   The Add database server dialog box appears.

   1. In the Host name box, type the host name.

   2. For the OS Type, click the operating system that is installed on the server.

   3. From the Software cache list, select the cache.

   4. Specify the server credentials or the user name and password:

      - To use saved credentials, move the Use saved credentials toggle to the right, then select a credential.

      - If you are not using saved credentials, click the add button and enter the User name and Password to be used.

   5. If you selected Unix as the operating system, do the following:

      1. In the SSH port number box, verify or change the port number.

      2. To use an SSH key, move the Use SSH key toggle to the right, and then in the SSH key path box, enter the file path.

      3. To use an SSH key file passphrase, move the Use SSH key file passphrase toggle key to the right, and then in the Passphrase box, enter the passphrase for the SSH key.

   6. From the Installation location (Optional), enter the directory path on the target server where the SQL Server package (Commvault software) will be installed.

   7. To use IntelliSnap operations, move the Install MediaAgent toggle key to the right.

   8. To install a restore-only agent, move the Restore only agent toggle key to the right.

      You can choose to install an agent in restore-only mode if you want to use the client only as a destination to restore backup data. Agents installed in this mode do not consume any licenses and do not allow backup operations.

   9. To reboot the server after the installation, move the Reboot if required toggle key to the right.

   10. Click Install. After the installation is complete, refresh the page and select the newly installed server from the list.

       Note

       You can click the job ID to monitor the installation progress.

3. Click Next.

4. From the Plan list, select a backup plan.

5. Click Next.

   The SQL server authentication dialog box appears

6. To use Use local system account, move the toggle to the right. This option runs SQL Server operations using the Windows Local System account on the client server.

7. From the Credentials list:

   - To use saved credentials, move the Use saved credentials toggle to the right, then select a credential.

   - If you are not using saved credentials, use the following steps to create a new one:

     Steps to create credentials

     1. Click the add button .

        The Add credential dialog box appears.

     2. For Account Type, select the authentication method to use for the SQL Server instance.

     3. For Credential Vault, select the credential vault to save the credentials in.

     4. In Credential name, enter a descriptive name for the credentials.

     5. In User account, enter the account that will be used for authentication.

     6. In Password, enter the password associated with the user account.

     7. In Email, enter the email address associated with the account.

     8. In Description, enter a description of the credentials.

     9. Click Save.

8. Click Next.

## Summary

1. Review the summary.

2. Click Finish.

×

Loading...