By using AWS re:Post, you agree to the Terms of Use
/Connection error RDS/

Connection error RDS


Hi, I am forwarding below the error presented when uploading the power bi via directquery with the PostrqSQL database stored in RDS.

Error: An error happened while reading data from provider: 'A connection attmpt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'

asked 2 months ago3 views
1 Answers

Hi @AWS-User-4367014, I'm new to RDS myself but am attempting to learn the technology, so, I figure troubleshooting would be one good place to start. Based on this article, you might want to check the following:

  • The RDS DB instance is in a state other than available, so it can't accept connections.
  • The source you use to connect to the DB instance is missing from the sources authorized to access the DB instance in your security group, network access control lists (ACLs), or local firewalls.
  • The wrong DNS name or endpoint was used to connect to the DB instance.
  • The Multi-AZ DB instance failed over, and the secondary DB instance uses a subnet or route table that doesn't allow inbound connections.
  • The user authentication is incorrect.

Based on the error message you're getting, it definitely sounds like a networking issue (security group or NACL).

Let us know if any of those don't point you in the right direction. I'd like to see what fixes this for you.

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions