CODEWITHSUNDEEP
sqlsql-serveramazon-web-servicesaws-dms
Juan Rey Hernández
Juan Rey Hernández

Reputation: 2868

AWS DMS. Endpoint connection fails in replication instance (Error: 1020912)

Create an endpoint, associated with my AWS-DMS instance, to connect to an On-premises SQL Server database and the test connections fails!!!

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

Upvotes: 2

Views: 27444

Answers (2)

Yvette Lau
Yvette Lau

Reputation: 441

I have this error when I was doing the databases migration cross-account.

If you have a source database in the source Account and a target database on the target Account.

First, you should setup the vpc peering connection (Note, VPC CIDR shouldn't overlapping.) Then you update the Route table for each other vpc cidr range.

Second, On the Target account, set up the source and target endpoint, replication instance. When you set up the replication instance, make sure it stays with the target endpoint VPC.

Third, update the source and target account database security group inbound rules, to allow the replication instance private IP address with the database port.

Then you should be able to test the source and target endpoint with the replication instance connection without this error.

Upvotes: 2

Mina Fawzy
Mina Fawzy

Reputation: 21452

make sure both use the same VPC plus security group

to use same VPC

create new subnet group under Subnet groups using same VPC for your On-premises Sql

Upvotes: 4

Related Questions