RDS connection issue

Question

Hello friends, I have this MSSQL database instance with Public Access and MSSQL Protocol and Port allowed for 0.0.0.0/0 into the Security Group for it, but it is impossible to me to get connected to this DB. However I can connect with other located into a different AZ with the same privileges. Somebody knows what I missed? Thanks in advance

Accepted Answer

More than likely it is a routing issue. I would first make sure that the VPC the DB instance resides in has an internet gateway attached to it. If it does, there could be a route missing or configured incorrectly (ingress most likely).

Here is a post on how to troubleshoot VPC routing:

https://repost.aws/knowledge-center/troubleshoot-vpc-route-table

Here is a post on how to troubleshoot VPC routing:

https://repost.aws/knowledge-center/troubleshoot-vpc-route-table

Answer

Be cautious about having databases in public subnets opening ports to everyone.

Thought convenient it can be maliciously exploited. Consider this: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/

RDS connection issue

Conteúdo relevante