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

about cdc migration

0

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
0

Hi

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: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Configuration

For on-prem: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC

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.

SUPPORT ENGINEER
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