Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankitpurohit
Contributor
Contributor

QlikSense SaaS to on prem SQL server connection issue

Hello,

 

Recently we setup Qlik Sense SaaS model for my company. On our side we worked on firewall config settion so we could make connection between Qlik Sense and on prem SQL servers. When tried I am getting below error message,

 

Error message:Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection

ERROR [08001] [unixODBC][Qlik][SqlServer] Failed to locate Server/Instance Specified.

Qlik sense is hosted on Qlik cloud and NOT on my company side.

Any assistance would be greatly appreciated.

Thanks. 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
Benoit_C
Support
Support

Hello @Ankitpurohit,

In order to be able to use SQL connector from your servers, you could try to use Qlik Data Gateway.

Data gateways provide a secure means of accessing or moving firewalled data for use in Qlik Cloud. The gateway is installed behind your organization's firewall, and then registered with Qlik Management Console:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g...

Regards,
Benoit

View solution in original post

1 Reply
Benoit_C
Support
Support

Hello @Ankitpurohit,

In order to be able to use SQL connector from your servers, you could try to use Qlik Data Gateway.

Data gateways provide a secure means of accessing or moving firewalled data for use in Qlik Cloud. The gateway is installed behind your organization's firewall, and then registered with Qlik Management Console:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g...

Regards,
Benoit