user10
user10

Reputation: 11

Facing issue while connecting aws rds(ssms) database to aws glue using jdbc

i Configured RDS instance and configuring it as Publicly accessible. (VPC private, Subnet private Subnet) and Attempted to connect to the RDS instance from rdp by creating ec2 instance and elastic up, the connection is successfull. after that i Updated the Inbound and Outbound rules to whitelist our elastic ip IPs as well.

i Checked the IAM role for RDS and AWS Glue service as well and noticed that we have all the necessary permission. As we are not able to connect in jdbc , i provide details of aws rds that i created in jdbc configuration but it is failed showing the status failed Py4JJavaError - An error occurred while calling o263.getDynamicFrame. : com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "xyzdataload" requested by the login. The login failed. ClientConnectionId:8d43df4a-5ae7-45345-a542-5c8307a7ddc7 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)

Upvotes: 0

Views: 22

Answers (0)

Related Questions