System Requirements for Amazon RDS for SQL Server

Verify that your environment meets the system requirements for Amazon RDS for SQL Server.

Amazon RDS for SQL Server Environment

The Amazon RDS for SQL Server environment must include the following:

• An Amazon RDS account

• An Amazon RDS SQL instance

• A dedicated Amazon S3 bucket for staging backups

• A Windows AWS backup gateway with the SQL Server package installed

• Configure the Amazon database instance to have the native backup and restore option enabled. For more information, go to the article Adding the native backup and restore option on the Amazon website.

  When configuring the backup and restore support, verify that the IAM role associated to the option group has access to the S3 bucket as configured in the Amazon RDS SQL S3 permissions file.

• An account that is one of the following:

  • The master user name of the instance

  • A non-master user name that has the required permissions. For more information, see Create a Non-Master User Account for Amazon RDS SQL Database Backups.

  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.

Access Nodes

• The following packages are required on access nodes:

  • SQL server

• Access nodes that you run backup and restore operations on must have one of the following operating systems:

Supported SQL Server Versions

• SQL Server 2022

• SQL Server 2019

• SQL Server 2017

• SQL Server 2016

Application

The Commvault Cloud software supports all versions and editions of Microsoft SQL Server that are supported by AWS. For more information, go to Microsoft SQL Server on Amazon RDS in the AWS documentation.