Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

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

Themen
Migration und ModernisierungAnalysenDatenbank
Tags
Amazon Relational Database Service
Sprache
English
rePost-User-6569945
gefragt vor einem Jahr244 Aufrufe
2 Antworten
1
Akzeptierte Antwort

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
beantwortet vor einem Jahr
profile pictureAWS
EXPERTE
secondabhi_aws
überprüft vor einem Jahr
  • rePost-User-6569945
    vor einem Jahr

    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
EXPERTE
Antonio_Lagrotteria
beantwortet vor einem Jahr
  • rePost-User-6569945
    vor einem Jahr

    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.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt