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?