SQL ODBC User Directory Connector

[baarathi]

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

[jrpereirajr]

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]

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