Error connecting to Amazon Redshift database to Qlik Sense

[Admin3]

I am trying to connect a Redshift DB to QlikSense but I am getting the following error:

ERROR[08S01][Qlik][Amazon Redshift](10) Error occured while trying to connect:[SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "XXXX" (XX.XXX.XXX.XXX) and accepting TCP/IP connections on port 5439?

All of the credentials are correct as I can connect to QA server.

Please refer the below error screenshot.

[stevejoyce]

@Admin3 - did you happen to resolve this?

[Sooraj_Suresh]

Hello @Admin3 

Is the Qlik server on the same VPC as AWS redshift is? If yes please check the network connection.

If the Qlik server is outside from the DB instance then make sure the security group is configured in such a way that it allows connections from external entity.

Regards

Sooraj Suresh

[Gary20 · Accepted solution]

I know the post is old but I found a solution. AWS Redshift serverless was my environment. Had to open port 5439 on Redshift even though Inbound & Outbound rules were 'accept all'. Still gotta open the port.