AWS DMS connection error ("password authentication failed")

Question

I configured source and target endpoint for DMS services, both of them are postgresDB one on EC2 machine, one on RDS.

When I test connection on both of them, I got the following error:

Operation:testEndpointDetails:[errType=ERROR_RESPONSE, status=122500, errMessage=Cannot connect to ODBC provider [122500] ODBC unkown error., errDetails= RetCode: SQL_ERROR SqlState: 28P01 NativeError: 210 Message: [unixODBC]FATAL: password authentication failed for user "docker" [122502] ODBC general error.]

What does that mean ? How could I possibly debug this ?

Any chance you figured this out? I am seeing the exact same thing pointing to two Posgtres DBs, both on RDS. — TehNrd

Seyed Ketabchi Seyed Ketabchi · Accepted Answer · 2016-11-08T21:26:05

you need to grant permission to user docker and / or use correct password when you defined the endpoints.

AWS DMS connection error ("password authentication failed")

1 Answers