topic User directory connector problem - SQL Server in Management & Governance https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188721#M7400 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>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?</P><P><IMG alt="qlik_userdirectoryconnector.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138011_qlik_userdirectoryconnector.PNG" style="height: 337px; width: 620px;" /></P><P>I have also tried the string:</P><P><SPAN style="color: #008000;">OLEDB CONNECT TO [Provider=SQLOLEDB;Data Source=SAFTINET;Initial Catalog=hc;]</SPAN></P><P></P><P>My encrypted string contains </P><P><SPAN style="color: #008000;">User Id=*****; Password=****;</SPAN></P><P></P><P>The error from Qlik is:</P><P><IMG alt="qlik_userdirectoryconnectorerror.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/138012_qlik_userdirectoryconnectorerror.PNG" style="height: 47px; width: 620px;" /></P><P></P><P>Thanks for any assistance.</P></BODY></HTML> Tue, 20 Sep 2016 12:26:49 GMT Lauri 2016-09-20T12:26:49Z User directory connector problem - SQL Server https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188721#M7400 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>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?</P><P><IMG alt="qlik_userdirectoryconnector.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138011_qlik_userdirectoryconnector.PNG" style="height: 337px; width: 620px;" /></P><P>I have also tried the string:</P><P><SPAN style="color: #008000;">OLEDB CONNECT TO [Provider=SQLOLEDB;Data Source=SAFTINET;Initial Catalog=hc;]</SPAN></P><P></P><P>My encrypted string contains </P><P><SPAN style="color: #008000;">User Id=*****; Password=****;</SPAN></P><P></P><P>The error from Qlik is:</P><P><IMG alt="qlik_userdirectoryconnectorerror.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/138012_qlik_userdirectoryconnectorerror.PNG" style="height: 47px; width: 620px;" /></P><P></P><P>Thanks for any assistance.</P></BODY></HTML> Tue, 20 Sep 2016 12:26:49 GMT https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188721#M7400 Lauri 2016-09-20T12:26:49Z Re: User directory connector problem - SQL Server https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188722#M7401 <HTML><HEAD></HEAD><BODY><P>Try using an ODBC connectstring instead of an OLEDB connectstring.</P></BODY></HTML> Wed, 21 Sep 2016 06:58:32 GMT https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188722#M7401 Gysbert_Wassenaar 2016-09-21T06:58:32Z Re: User directory connector problem - SQL Server https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188723#M7402 <HTML><HEAD></HEAD><BODY><P>That works, thank you, Gysbert!</P></BODY></HTML> Sat, 24 Sep 2016 11:03:07 GMT https://community.qlik.com/t5/Management-Governance/User-directory-connector-problem-SQL-Server/m-p/1188723#M7402 Lauri 2016-09-24T11:03:07Z