Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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

Argomenti
Migrazione e modernizzazioneAnalisiDatabase
Tag
Amazon Relational Database Service
Lingua
English
rePost-User-6569945
posta 10 mesi fa242 visualizzazioni
2 Risposte
1
Risposta accettata

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
con risposta 10 mesi fa
profile pictureAWS
ESPERTO
secondabhi_aws
verificato 10 mesi fa
  • rePost-User-6569945
    10 mesi fa

    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
ESPERTO
Antonio_Lagrotteria
con risposta 10 mesi fa
  • rePost-User-6569945
    10 mesi fa

    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.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente