Add an Amazon RDS SQL Instance

After you configure the app for Amazon RDS, add a SQL server for each Amazon RDS instance that is part of the account.

Procedure

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

   The Overview page appears.

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

   The Vendor page appears.

3. Select Amazon Web Services and then click NEXT.

   The Select A Database Service page appears.

4. Select RDS Export, and then click NEXT.

   The Select Database page appears.

5. Select SQL server, and then click NEXT.

   The Select A Plan page appears.

6. From the list of backup plans, select a backup plan, and then click NEXT.

   The Cloud Account page appears.

7. From the Cloud Account list, select an Amazon RDS cloud account or configure a new cloud account.

   To configure a new cloud account, complete the following steps:

   1. Click +.

      The Add cloud account page appears.

   2. In the Name box, type the name for the account.

   3. In the Regions box, type the region where the Amazon RDS instance is located.

   4. Enter the host or account authentication information:

      • IAM role: To authenticate the Amazon RDS cloud account, select this option.

      • STS assume role with IAM policy: To authenticate the Amazon RDS cloud account using a security token service (STS) assume role, select this option, and from the Credentials list, select the credential for the Amazon RDS cloud account.

        To apply an IAM policy for the hypervisor when you use this authentication method, you can attach an IAM policy with sts:AssumeRole to the access node in the AWS Console. For more information about STS role authentication, see Configuring STS Role Authentication.

      • Access and secret key: To authenticate the Amazon RDS cloud account using an access key and a secret key, select this option, and from the Credentials list, select the credential for the Amazon RDS cloud account.

   5. From the Access nodes list, select the access nodes to use for the instance.

   6. Click SAVE.

8. Click NEXT.

   The Backup Content page appears.

9. From the Instance name list, select the SQL Server instance that you want to protect.

10. In the S3 bucket name box, enter the S3 bucket name for the Amazon S3 cloud account.

    Use a pre-created S3 bucket on the RDS instance.

11. From the SQL server authentication list, select an existing credential or new credential for the SQL server.

    Steps to add new credential

    1. Click the add button .

       The Add credential dialog box appears.

    2. The Account type, Database type, and Credential Vault are selected by default.

    3. In the Credential name box, enter the name for the credential.

    4. In the Username box, enter the user name to access the application.

    5. In the Password box, type the password to access the application.

    6. In the Description box, enter a description of the credentials.

    7. Click SAVE.

    Note

    To use an Active Directory (AD) account for the backup, configure an Active Directory admin for that instance on the Amazon AWS portal. The AD account must be a local administrator on the access node and along with all permissions for a non-master user must have a “Create any database” securable permission on the RDS SQL instance. You must enter the user details in user_name@domain_name format. 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.

12. To specify a custom port to be used for the instance, in the Port box, type the port number.

13. Click NEXT.

    A summary page for the instance is displayed.

14. Click FINISH.