Not being able to connect to my aws rds database from data migration assistant

Question

I am trying to migrate data from aws rds to azure sql managed instance but i having error while connecting to my target server (aws rds). I am using <endpoint>,<port> notation.

This is the error i am facing:
Connection to the server failed.

Validator 'Microsoft.SqlServer.Migration.Core.Validators.SupportedDatabaseEnvironmentValidator' failed to validate data.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)

No such host is known

Answer 1

When you set the connection to AWS RDS, please check the "Encrypt connection" and "Trust server certificate" as shown below.

Make sure you can connect to Azure RDS using other tools like SSMS. Make sure the database is publicly accessible and allow connections from the public IP where the host with DMA installed is located.

Finally, see this troubleshooting documentation published by Amazon.