about endpoint connection
We have created a VPC to connect to the on prime database using AWS DMS. I am able to ping the on prime database server and connect my mssql database using Azure data studio from the VPC but my DMS is not able to connect to my mssql database on private ip. Except captured while testing the connection in following: """Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to connect Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired"""
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.
Accessing a RDS database in another account using AWS PrivateLinkAccepted Answerasked 4 years ago
about endpoint connectionasked a month ago
Can't connect to RDS database from remoteasked 5 months ago
Lightsale instances cannot connect to Lightsail databaseasked 6 months ago
migrate database from my local to AWSAccepted Answerasked 3 years ago
Can QuickSight connect to Azure SQL Database?EXPERTasked 7 months ago
About DMS migration from ms-sql to dynamodbasked 24 days ago
Is there a service to move a database from MSSQL to MySQL (both hosted on AWS)asked 5 months ago
Created RDS database, Cannot connect via Microsoft SQL Server Studioasked 3 years ago
Can't connect to an RDS Instance from Lambda (different account tough)asked 2 years ago