Unable to add SQL User directory connector

[shirenmathai]

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;

[Levi_Turner]

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

[shirenmathai]

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]

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;