I have created a cluster in Amazon Redshift Database and have configured security inbound rules. When trying to connect to it using SQLWorkbench client tool I get the following error.
AmazonError setting/closing connection: Operation timed out.
I have one more cluster configured to the same security inbound rules and I can be able to connect to it. Error is specific to this particular cluster.
Please help!!!
Here are most likely causes.
1) Wrong hostname or port
2) Publicly Accessible is set "NO" in your Redshift cluster configuration (Only VPC)
If you launched your Redshift cluster in VPC, Publicly Accessible: needs to be YES to access from outside VPC.
3) VPC security group is not configured correctly
There are two patterns to setup security groups to access Redshift.
I recommend you to check if you setup the correct security group settings along with the place where you launched your Redshift cluster.
If you still cannot solve this issue, it's better to check the following Redshift trouble shooting docs.
