topic MS SQL Server pass-through authentication in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-Server-pass-through-authentication/m-p/1245341#M2423 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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. </P><P></P><P>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.</P><P></P><P>Has anybody out there managed to get pass-through authentication working?</P><P></P><P>Cheers,</P><P>Kjetil</P></BODY></HTML> Thu, 09 Feb 2017 15:21:58 GMT 2017-02-09T15:21:58Z MS SQL Server pass-through authentication https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-Server-pass-through-authentication/m-p/1245341#M2423 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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. </P><P></P><P>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.</P><P></P><P>Has anybody out there managed to get pass-through authentication working?</P><P></P><P>Cheers,</P><P>Kjetil</P></BODY></HTML> Thu, 09 Feb 2017 15:21:58 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-Server-pass-through-authentication/m-p/1245341#M2423 2017-02-09T15:21:58Z