Getting error in AWS DMS Source Test endpoint connection

Question

Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to connect Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: [unixODBC]FATAL: password authentication failed for user "user"

I am trying to Implement as per this video and the article (link provided below). When I am trying to do connection test for source Endpoint, I am getting the above error. But I am able to connect to the db from DMS query Editor https://dev.to/omarrosadio/implementing-change-data-capute-cdc-with-aurora-serverless-v2-4i1l

https://www.youtube.com/watch?v=uIqKtn2vbsU

Answer 1

We had a similar very similar migration project in my company. We ended up realizing that running simple automation scripts worked faster and had less issues than using DMS.

To answer you questions:

If it is only for test, and not production I see in the link you provided that the Aurora Serverless Parameter Config isn't set or changed. Is it already accepting all required traffic types you need? Have you tested it? If not, then I recommend using the AWS Access Analyzer to check where the bottlenecks are, or a simple temporary instance for smoke tests.