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

Nischay 0 Reputation points
2023-12-12T12:10:14.9933333+00:00

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

Azure Database Migration service
Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,341 Reputation points MVP
    2023-12-12T17:01:23.8733333+00:00

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

    User's image

    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.

    0 comments