Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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

Temas
Migración y modernizaciónAnálisisBase de datos
Etiquetas
Amazon Relational Database Service
Idioma
English
rePost-User-6569945
preguntada hace 10 meses242 visualizaciones
2 Respuestas
1
Respuesta aceptada

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
respondido hace 10 meses
profile pictureAWS
EXPERTO
secondabhi_aws
revisado hace 10 meses
  • rePost-User-6569945
    hace 10 meses

    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
EXPERTO
Antonio_Lagrotteria
respondido hace 10 meses
  • rePost-User-6569945
    hace 10 meses

    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.

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante