By using AWS re:Post, you agree to the Terms of Use

about cdc migration


hlw , actually i am tring to mingrate cdc data but found the erroe , please help me as soon as possible

"Last Error Fatal error has occurred Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2880] [1022505] Failed (retcode -1) to execute statement; RetCode: SQL_ERROR SqlState: 42000 NativeError: 20028 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The Distributor has not been installed correctly. Could not enable database for publishing. Line: 1 Column: -1; Failed while preparing stream component 'st_0_NXRYOCRQYP462UX5EWX5NRDDUDPXLYCNC7TV5JI'.; Cannot initialize subtask; Stream component 'st_0_NXRYOCRQYP462UX5EWX5NRDDUDPXLYCNC7TV5JI' terminated [reptask/replicationtask.c:2888] [1022505] Stop Reason FATAL_ERROR Error Level FATAL" Source endpoint: Target endpoint: Migration task (ARN): Timestamp:

1 Answers


From the error shared, this seems to be a situation that required steps not met.

Depends on what is the source SQL Server (RDS SQL Server or on-prem SQL Server)

For RDS SQL Server:

For on-prem:

Also make sure the user used here for on-prem server (sysadmin or non-sysadmin) as there are two sets of steps mentioned in the public doc.

answered a month 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