RDS connection issue

0

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

已提問 1 年前檢視次數 246 次
2 個答案
1
已接受的答案

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

profile pictureAWS
JHaddix
已回答 1 年前
profile pictureAWS
專家
已審閱 1 年前
  • That was exactly the issue, thanks a lot my friend. Very good job helping me, I really own you a favor lol, so thanks again and again and again.

1

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/

profile picture
專家
已回答 1 年前
  • Yes I know it and I strongly agree with that, I´m just trying to discover the reason of this problem. Anyway thanks for your advertisement, I'm aware of that.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南