Issues creating UDC with SQL Server

[rajeshbheeman]

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. 

I would really appreciate any assistance/guidance on this.