Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
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=20.193.50.143;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?

 

Baarathi

Thanks and Regards
SQLODBC.PNG

 

Labels (4)
2 Replies
jrpereirajr
Contributor
Contributor

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;

phdBender
Partner - Contributor
Partner - Contributor

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