AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.
DMS error - Failed to get the capture list from the endpoint
Hi - I am trying to replicate data from SQL Server to S3, the endpoint testing for both source and target is successful, however while starting the task, I get the below error - Failed to get the capture list from the endpoint. Any advise ?
- Language
- English
- Newest
- Most votes
- Most comments
Hello.
Have you cleared all the prerequisites when targeting S3 with DMS?
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html#CHAP_Target.S3.Prerequisites
Although it may not be very relevant, try creating an S3 VPC endpoint in the VPC where the DMS replication instance is located and see if it improves.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_VPC_Endpoints.html
DMS expects the username to be dms_user whilst connecting to SQL server. Once this new user is created, the task gets completed successfully. The below documentation has further details related to it.
Relevant content
- AWS OFFICIALUpdated 6 months ago
Hey, thanks for the response. Those pre-reqs are in place, I managed to fix the issue. DMS expects the username to be dms_user whilst connecting to SQL server. Once this new user is created, the task completed successfully. The below documentation has further details related to it.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Permissions