Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

SQL ODBC User Directory Connector

I am trying to connect sql users to qmc, using User Directory Connectors, getting the following error. I have given


visible connection string as Driver={SQL Server Native Client 11.0};Server=;Port=53008;Database=TestDB;Trusted_Connection=yes;uid=Jaki;pwd=1234

Where Jaki and 1234 are user id and password of database which is located in another machine.

In Encrypted Connection String I have given the administrator's Userid and password of machine in which qmc is installed. Any feedback or correction need to be made on above?



Thanks and Regards


Labels (4)
2 Replies

I know that is a 3 years old question, but even so I'd like to share that, by setting up user and password in "Encrypted connection string" field, worked for me.

My configuration was something like this:

User table name: schema.MyUserNameTable

Attributes table name: schema.MyUserAttributesTable

Visible connection string: DRIVER={xxxx};SERVER=x.x.x.x;PORT=xxxxx;DATABASE=xxxxxx;

Encrypted connection string: UID=user;PWD=password;

Partner - Contributor
Partner - Contributor

Jrpereirajr, Thanks a lot. Your answer is helpfull for me!