Add the Access Node for Amazon RDS for SQL Server

Add the access node for Amazon RDS for SQL Server.

Before You Begin

• The access node must be a Windows SQL EC2 client with internet access.

  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.

• Port 1433 must be open on the access node so that it can connect to the Amazon RDS for SQL Server instance.

• You need the following information:

  • Host name

  • User name and password or saved credentials

  • OS type

Procedure

1. From the navigation pane, go to Manage > Servers.

   The Servers page appears.

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

   The Add Server dialog box appears.

3. Select one of the following installation methods:

   • To install software on the computer, click Install software packages on your computer, and then enter the following information:

     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. To specify the software cache, 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, 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 Select packages list, select Virtual Server and Cloud Apps, and then click OK.

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

     8. To specify the installation location, in the Installation location box, enter the path.

     9. 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.

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

   • To complete an installation when the software is already installed on the server, click Complete the installation if the software packages are already installed on your computer, and then enter the following information:

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

     2. To assign a specific name to the server, in the Server name box, enter the name.

4. Click INSTALL.