Failed to validate connection to RDS within QuickSight dataset

0

I'm following the guide for analytic practice in here: https://aws.amazon.com/getting-started/hands-on/visualize-data-amazon-rds-sql-server-using-amazon-quicksight/?ref=gsrchandson&id=itprohandson

In the 8.i step, while adding new dataset in RDS for QuickSight, it appears connection timeout error Enter image description here

I've setup the inbound and outbound settings following the guide, and I've created the table from MS SQL server studio. Can anyone help me with this connection problem? Thanks

demandé il y a 2 mois150 vues
1 réponse
0

Usual issues are : 1- RDS Security group not allowing inbound from Quicksight 2- NACL on the subnet blocking traffic (if multiple subnets are involved) 3- RDS Subnet group not having all private subnets (May be one or two are public subnets) 4- Quicksight not using VPC connection.

AWS
EXPERT
répondu il y a 2 mois
profile picture
EXPERT
vérifié il y a 2 mois
  • Hello, thanks for response. I've alread added the VPC connection to QuickSight, and the VPC IP is under the VCP security group that have inbound and outbounds settings: Inbound: allow all TCP and all streaming Outbound:allow all streaming

    The VPC connection I added to QuickSight use all 3 SubNet which is available. I'm not sure what can I test for checking.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions