Hi all,
I am trying to setup UDC with SQL Server and couldn't get it working. Please find the details below.
Tables:
create table qlikuser(userid varchar(50), name varchar(300))
create table qlikuserattribute(userid varchar(50), type varchar(100), value varchar(300))
Inserts:
insert into qlikuser values('test.user', 'Test User')
insert into qlikuserattribute values('test.user', 'email', 'test.user@gmail.com')
Visible connection string:
Driver={SQL Server Native Client 11.0};Server="10.01.01.01";Database=TestDB;uid=testuser;pwd=testpw!2#;Trusted_Connection=yes;
testuser has db_admin privilege on TestDB
Attaching screenshot showing the same.
![UDC_Error.PNG UDC_Error.PNG](https://community.qlik.com/t5/image/serverpage/image-id/42352i7776813351E22A59/image-size/large?v=v2&px=999)
I would really appreciate any assistance/guidance on this.