Manually enabling access to an Amazon RDS instance that is not in a VPC - Amazon QuickSight

Manually enabling access to an Amazon RDS instance that is not in a VPC

Use the following procedure to access an Amazon RDS DB instance that is not in a VPC. You can associate a security group with a DB instance by using Modify on the RDS console, the ModifyDBInstance Amazon RDS API, or the modify-db-instance AWS CLI command.

Note

This section included for backwards compatibility purposes.

To use the console to access an Amazon RDS DB instance that is not in a VPC

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. Choose Databases, select the DB instance, and choose Modify.

  3. Choose Security Groups in the navigation pane.

  4. Choose Create DB Security Group.

  5. Enter Amazon-QuickSight-access for the Name and Description values, and then choose Create.

  6. The new security group is selected by default.

    Select the details icon next to the security group, as shown following.

    DB Security Groups table showing amazon-quicksight-access with no-authorizations status.

  7. For Connection Type, choose CIDR/IP.

  8. For CIDR/IP to Authorize, enter the appropriate CIDR address block. For more information on the IP address ranges for Amazon QuickSight in supported AWS Regions, see AWS Regions, websites, IP address ranges, and endpoints.

    Input field for CIDR/IP address to authorize access, with an example IP address shown.

  9. Choose Authorize.

  10. Return to the Instances page of the Amazon RDS Management Console, choose the instance that you want to enable access to, choose Instance Actions, and then choose Modify.

  11. In the Network & Security section, the currently assigned security group or groups already is chosen for Security Group. Press CTRL and choose Amazon-QuickSight-access in addition to the other selected groups.

  12. Choose Continue, and then choose Modify DB Instance.