Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor 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