This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 17%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Between On-premise SQL server database and the AWS RDS service for SQL Server, I have set up the AWS DMS sync. Having the following problem right now. Kindly help to troubleshoot this issue. What does the error code mean in the below messages?
22-11-10T05:05:02:246333 [SOURCE_CAPTURE ]D: Connection failure error codes are: 00026,00904,10054,4060,01222,55,64,121,1231,233,109,18401,6005,40613 (provider_syntax_manager.c:2114)
2022-11-10T05:05:02:246381 [SOURCE_CAPTURE ]D: Fatal error codes are: 20028,18470 (provider_syntax_manager.c:2202)
2022-11-10T05:05:02:246389 [SOURCE_CAPTURE ]D: Table error codes are: 16943,208,11529,1904,1750,8180,207 (provider_syntax_manager.c:2173)
2022-11-10T05:05:02:246397 [SOURCE_CAPTURE ]D: Data failure error codes are: 7125,8114,6522,511 (provider_syntax_manager.c:2144)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 15%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
I had exactly the same error messages with not-so-descriptive error codes, and DMS task is stopping with failure.
In my case, the fix was using sa as the user to access and hook into the database cdc.
HTH.
Hi, @Satheesh Kumar Thiyagarajan
This error log is an error log output by AWS DMS.
So asking a question in Microsoft Q&A is probably not appropriate.
You should ask the community on AWS re:Post or use AWS paid support.
Hi @Satheesh Kumar Thiyagarajan ,
I'm agree that it is the AWS problem. Maybe you can post questions in this link: https://iq.aws.amazon.com/services/aws/dms ( I'm not sure if it is the official web, I just search on my own)