I’m trying to create an AWS RDS instance that’s connected to by an EC2 instance. I have two security groups and one RDS instance, which I’m creating using Cloud Formation. You can see my .yaml file below:

I have a CloudFormation nested stack in Account A that creates various resources including an RDS instance from a snapshot (Aurora Serverless). Let’s call this snapshot “snapshotA”. Now, all these resources are provisioned in Account A.

I wrote a stack containing an RDS Database, proxy and Target group but seem to run into a weird issue when deploying it. When opening the rdsproxy it says the database is unavailable in the Target group section. If i then in the rds proxy (aws GUI) press Actions -> Modify (In this view i don’t touch anything) I just click modify at the end of the page. After reload it says available and everything works.