topic Re: Unable to connect to database using qlickcloud in Connectivity & Data Prep

Unable to connect to database using qlickcloud

STS — Mon, 13 Dec 2021 21:49:21 GMT

In Qlik cloud I created new app with new connection to Microsoft Azure SQL database. Connection test worked fine. Then I was able to see the data through "Select data" option. Script was inserted without any issues as well. But then I try to load data I get this error message:

The following error occurred:

(Connector error: Unable to connect to database: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: General error)

The same load script in Qlik Sense desktop version works fine.

Any ideas what can be wrong?

Re: Unable to connect to database using qlickcloud

deepakqlikview_123 — Sat, 22 Feb 2020 15:46:15 GMT

please check your firewall settings.

and port using telnet followed by ip of the server and port,

Re: Unable to connect to database using qlickcloud

STS — Thu, 27 Feb 2020 08:52:48 GMT

While trying to figure out what can be wrong I found out, that it was not a server issue. It was Qlik cloud connector issue. It looks like it is not able to save the password. If I type username/password, test the connection and load data right away - it loads fine. The next time I try to load it - I get that error message.

P.S. Does anybody knows go to reach Qlik support? Once I press on "Submit a case" I get a new window where I can select "I have an issue with Qlik Sense cloud" but login button just opens a front page.

Re: Unable to connect to database using qlickcloud

patricesalem — Thu, 02 Jul 2020 08:25:01 GMT

did you get any feedback to your issue ?

We've the same issue here since thursday (Qlik Sense Server Sept 2019 version)

Thanks

Re: Unable to connect to database using qlickcloud

STS — Thu, 02 Jul 2020 08:32:39 GMT

Yes, after I made some changes in the load script it started to work. But it was some time ago, I don't remember what changes I applied to the script.

It was on Qlik Cloud services.