Qlik Community

Ask a Question

Support Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW

How to set up Single Sign-On ODBC Connection to SQL Server from Qlik Sense

Sonja_Bauernfeind
Digital Support
Digital Support

How to set up Single Sign-On ODBC Connection to SQL Server from Qlik Sense

Single Sign-On for Microsoft SQL Server is introduced in Qlik Sense February 2018.
Instruction to set up this feature can be found on Qlik help site.

This article demonstrates an example following the instruction, including a step-by-step guide and some configuration notes.


Environment:

  • Qlik Sense February Enterprise on Windows any version

Limitation:

  • When using SSO data connection, the connection is done as "current user". When doing reload in HUB > Script Editor, current user is the logged in user. But when doing reload from QMC or via Tasks, current user is INTERNAL\SA_SCHEDULER.
  • As a limitation, SSO data connections may only be used in manual reload but not in QMC or Task reload.
Labels (2)
Attachments
Version history
Revision #:
2 of 2
Last update:
‎2020-12-21 06:45 AM
Updated by:
 
Contributors