- 新しい順
- 投票が多い順
- コメントが多い順
Hello
Seems like your On-premise SQL Server is not allowing connections from DMS Replication Instance(RI). Please consider the below troubleshooting steps to fix the connectivity issue.
-
Check if the route table, NACL, Security Groups of DMS RI are same as like the instance which you had no issues in connecting to the On-prem SQL Server from Azure Data studio.
-
Make sure that RI IP Address is added in the On-prem network to allow the inbound connections for SQL Server from the VPC where DMS RI is associated.
-
Verify if the outbound rules of RI are allowed to communicate with On-prem network. Outbound rules for RI is most important in establishing communication with source and target endpoints.
Further I would recommend going through the below Knowledge center article that helps you in troubleshooting DMS endpoint connectivity issues.
https://aws.amazon.com/premiumsupport/knowledge-center/dms-endpoint-connectivity-failures/