0 Replies Latest reply: Feb 9, 2017 10:21 AM by Kjetil Halvorsen RSS

    MS SQL Server pass-through authentication

    Kjetil Halvorsen

      Hi All,

       

      I have tried setting up pass-through authentication to MS SQL Server via ODBC by using the new "Single Sign-on" feature in Qlik Sense 3--I have tried 3.1SR4 and 3.2. However, I am unable to get the user's credentials passed to SQL Server. When I trace the connections as viewed by SQL Server, it always seems as if it is the Qlik Sense Server service user that is being used for authentication.

       

      I get the same result no matter which combination of settings I use: enable/disable SSO, entering credentials in the input fields/leaving them blank.

       

      Has anybody out there managed to get pass-through authentication working?

       

      Cheers,

      Kjetil