User directory connector problem - SQL Server

[Lauri]

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?

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:

Thanks for any assistance.

[Gysbert_Wassenaar · Accepted solution]

Try using an ODBC connectstring instead of an OLEDB connectstring.

[Lauri]

That works, thank you, Gysbert!