AWS DMS Resolving 'Failed to Retrieve Capture List' Error in MSSQL to MySQL Migration


Hi Team,

I have an MSSQL database on Microsoft Azure, and I'm planning to migrate data from one table to an AWS EC2 instance running MySQL. However, when I execute the migration task, I encounter the following error:


Last Error: Failed to retrieve the capture list from the endpoint. Stop Reason: FATAL_ERROR Error Level: FATAL


Could someone please guide me on resolving this issue? Additionally, I'd appreciate instructions on how to successfully migrate a single table from MSSQL to MySQL.

Thanks, Krishnakumar K

1 Answer


This error usually indicates an issue with the source endpoint configuration or network connectivity between AWS DMS and the source database.

Check Endpoint Configuration: Ensure that the source endpoint for the MSSQL database is correctly configured in AWS DMS. Verify the connection details like server name, port, and credentials. Confirm that the specified database user has the required permissions to read the database objects.

Network Connectivity: Check if the AWS DMS instance can reach the MSSQL database hosted on Azure. Verify that there are no network issues like firewalls or security groups blocking the connection.

Regards, Andrii

profile picture
answered 20 days 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