This role helps you troubleshoot AWS Relational Database Service (RDS) connectivity issues from an EC2 instance. The role diagnoses connectivity issues between an EC2 instance and an Amazon Relational Database Service instance by ensuring that the RDS instance is available and checking the associated security group rules, network access control lists, and route tables for potential connectivity issues. To do this, the role will need the EC2 instance identifier to test connectivity from the RDS instance identifier to connect to.
The role shows that there is an issue with the security group rules from the VPC where the RDS instance is running.
With the update of the security group rule, the EC2 instance can now contact the RDS instance.