Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Are you defining the schema? Reference SQL UDC based on views
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;
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;