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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
zahrael
Contributor II
Contributor II

sql server connexion problem

a3.pnga.pnga1.png

Labels (1)
1 Solution

Accepted Solutions
Andre_Sostizzo
Digital Support
Digital Support

@zahrael, from the screenshot you provided it looks like you are using Qlik Sense SaaS, in which you cannot use the native ODBC option because there's no way you can install 3rd party drivers yourself, as it is done in a Client-Managed Qlik Sense server deployment. 

I would investigate if you have your MS SQL server exposed to the internet in your Firewall configuration, and that the proper ports are open for inbound requests. Here are the Qlik Sense SaaS IP and DNS considerations:

https://community.qlik.com/t5/Knowledge/Qlik-Sense-SaaS-editions-IP-addresses-and-DNS-names/ta-p/171...

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂

View solution in original post

5 Replies
dwforest
Specialist II
Specialist II

DId you try "localhost" or the actual name of the server instead of .

Ranganath_DR
Support
Support

Hi @zahrael ,

Refer below link and see if it helps to setup the connection.

https://community.qlik.com/t5/Knowledge/Error-08001-Qlik-SqlServer-Failed-to-locate-Server-Instance/...

 

zahrael
Contributor II
Contributor II
Author

I try it , but same probleme 

zahrael
Contributor II
Contributor II
Author

thank you !

ODBC works for qlik sense desktop but  ODBC data source not existe for qlik sense hub

Capture d’écran 2021-08-09 140934.png

Andre_Sostizzo
Digital Support
Digital Support

@zahrael, from the screenshot you provided it looks like you are using Qlik Sense SaaS, in which you cannot use the native ODBC option because there's no way you can install 3rd party drivers yourself, as it is done in a Client-Managed Qlik Sense server deployment. 

I would investigate if you have your MS SQL server exposed to the internet in your Firewall configuration, and that the proper ports are open for inbound requests. Here are the Qlik Sense SaaS IP and DNS considerations:

https://community.qlik.com/t5/Knowledge/Qlik-Sense-SaaS-editions-IP-addresses-and-DNS-names/ta-p/171...

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂