topic Re: Qlik Sense Cloud Business - SQL Server Connection in Connectivity & Data Prep

Qlik Sense Cloud Business - SQL Server Connection

davidganly — Fri, 02 Apr 2021 07:54:51 GMT

After testing Qlik Sense Cloud for Business connector to Sql Server (Beta) i keep getting connection broken. Using the exact same process using Qlik Sense Desktop i can authenticate the connection without issue. I am using the Add Data wizard within QSCB.

I have white listed the ip addresses as per Microsoft SQL Server ‒ Qlik Connectors

I have stated a trial to test this functionality so time is ticking

How can i troubleshoot this connection?

Re: Qlik Sense Cloud Business - SQL Server Connection

davidganly — Sat, 01 Jul 2017 07:10:46 GMT

For those who may get stuck with this.

As i am hosting my sql server on Azure it was difficult to see what IP Range the inbound connection is coming from.

I enabled login logging on the sql server instance for both failed and successful login attempts.

I then opened a test * in my inbound firewall from any data source to my sql server. In the sql server log i was then able to see what the ip address that was trying to login from Qlik Cloud.

Clear from the documentation that they are missing a range of IP Addresses coming from Qlik Cloud. I added 34.249.54.0/28 to my whitelist and the connection worked. hope this saves somebody the amount of hours i put it into it....

Re: Qlik Sense Cloud Business - SQL Server Connection

davidganly — Fri, 22 Sep 2017 17:24:25 GMT

update:

looks like new ip ranges are being added to cloud with no addition to documentation in link above.

when using the beta of the SQL Server connection these must be white listed within the firewall where the database resides.

mto‌ great if you could have somebody look at the online documentation.

the ranges i have added that work are:

34.248.202.0/24

34.249.54.0/24

24.201.223.0/28

13.210.1.0/28

34.253.190.0/28

Re: Qlik Sense Cloud Business - SQL Server Connection

gcamargo — Fri, 18 Mar 2022 11:47:56 GMT

Hey David,

That white list is still working for you?