2 Replies Latest reply: Sep 24, 2016 7:03 AM by Lauri Scharf RSS

    User directory connector problem - SQL Server

    Lauri Scharf

      Hello, In Qlik Sense 3.0 server, I am unable to connect a user directory connector to SQL Server. I have no trouble with data connections to the same SQL Server in the apps. Is there an obvious error below?

       

      And if I get this connector to work, am I going to need to add an authentication layer? Or does Qlik take care of that?

      qlik_userdirectoryconnector.PNG

      I have also tried the string:

      OLEDB CONNECT TO [Provider=SQLOLEDB;Data Source=SAFTINET;Initial Catalog=hc;]

       

      My encrypted string contains

      User Id=*****; Password=****;

       

      The error from Qlik is:

      qlik_userdirectoryconnectorerror.PNG

       

      Thanks for any assistance.