Qlik Community

Ask a Question

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shirenmathai
Partner
Partner

Unable to add SQL User directory connector

Unable to add sql user directory connector. I have added two tables in sql database as shown in screenshot and trying to connect using sql authentication. Used below format for connection string. SQL Server Native Client 11.0 already available on the server. Please correct me if i'm wrong on any steps

Driver={SQL Server Native Client 11.0};Server=xxx.xxx.xxx.xxx;Database=Reports;User Id=Username;Password=xxxxxx;

screen1.JPG

screen2.JPG

screen3.JPG

3 Replies
Levi_Turner
Employee
Employee

Are you defining the schema? Reference SQL UDC based on views

shirenmathai
Partner
Partner

Yes i have tried using schema also like dbo.Dim_Users. I'm using sql authentication to connect the database. So can you please confirm whether im using the correct syntax

Driver={SQL Server Native Client 11.0};Server=xxx.xxx.xxx.xxx;Database=Reports;User Id=Username;Password=xxxxxx;

shirenmathai
Partner
Partner

Issue was with the syntax. Username and password should be like Uid & Pwd

Driver={SQL Server};Server=xxx.xxx.xxx.xxx;Database=Reports;Uid=TestUser;Pwd=xxxxx;