topic Re: Unable to add SQL User directory connector in Management & Governance

Unable to add SQL User directory connector

shirenmathai — Wed, 31 Jan 2018 12:45:36 GMT

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;

Re: Unable to add SQL User directory connector

Levi_Turner — Thu, 01 Feb 2018 00:49:39 GMT

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

Re: Unable to add SQL User directory connector

shirenmathai — Thu, 01 Feb 2018 04:55:41 GMT

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;

Re: Unable to add SQL User directory connector

shirenmathai — Thu, 01 Feb 2018 05:03:15 GMT

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;