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 EC2 client with SQL Server agent installed that will be used as the access node. If the client accesses Amazon RDS through a proxy server, then the user that runs the Commvault services must have the proxy settings configured through Internet Explorer. If the Commvault services run under a local system account, then perform the following steps to set the proxy settings:
-
To open a command window with the local system account, run the following command:
psexec.exe -i -s -d cmd.exe
-
To confirm the user account, run the following command:
whoami.exe
-
To set the proxy server, run the following command:
iexplore.exe
If you use the Access and Secret Key method for authentication, you can use an EC2 or an on-premises SQL client as the access node.
-
-
An account that is one of the following:
-
The master user name
-
A non-master user name that has the required permissions. For more information, see Creating a Non-Master User Account for Amazon RDS SQL Database Backups.
-
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:
Operating system |
Processor architecture |
---|---|
Red Hat Enterprise Linux 9.x, 8.x |
|
Rocky linux 9.x, 8.x |
|
Supported Oracle Versions
-
SQL server 2022
-
SQL server 2019
-
SQL server 2017
-
SQL server 2016
User Account Requirements
You do not require a root user account to install or operate the export-based backup and recovery solution. Use a non-root user account with sudo privileges for the installation and operations. For more information, see installation of UNIX agents by a non-root user with sudo privileges.
Application
The Commvault software supports all versions and editions of Microsoft SQL Server that are supported by AWS. For more information, see Microsoft SQL Server on Amazon RDS in the AWS documentation.