Failed to run connection test on Redshift endpoint in AWS DMS service

Asked Nov 09 '17 at 17:53

Active Nov 09 '17 at 17:53

Viewed 698 times

I have created an Redshift endpoint in AWS DMS service.

When I run the test connection I get the following error message:

Error Details: [errType=CALL_SERVER_ERROR, status=0, errMessage=Failed executing command on Replication Server, errDetails=]

Both the DMS replication instance and Redshift cluster are at the same region and in the same VPC.

asked Nov 09 '17 at 17:53

Cyrus

did you give the DMS IP address access to redshift cluster via the inbound rules on redshift? – Jon Scott Nov 09 '17 at 20:32
do you mean through VPC? – Cyrus Nov 09 '17 at 20:46
yes - the VPC security group you have for redshift must have an inbound rule for port 5439 for the IP address (external) of your replication instance(s) – Jon Scott Nov 10 '17 at 07:50

0 Answers0