topic Re: Error connecting to Amazon Redshift database to Qlik Sense in Connectivity & Data Prep

Error connecting to Amazon Redshift database to Qlik Sense

Admin3 — Sun, 06 Jun 2021 12:39:20 GMT

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.

Re: Error connecting to Amazon Redshift database to Qlik Sense

stevejoyce — Thu, 07 Oct 2021 21:08:33 GMT

@Admin3 - did you happen to resolve this?

Re: Error connecting to Amazon Redshift database to Qlik Sense

Sooraj_Suresh — Sat, 09 Oct 2021 10:11:13 GMT

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

Re: Error connecting to Amazon Redshift database to Qlik Sense

Gary20 — Thu, 30 Mar 2023 14:50:14 GMT

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.