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年前244ビュー
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.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ