1 Answer
- Newest
- Most votes
- Most comments
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.
Relevant content
- asked 10 months ago
- asked 9 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago