Using NTLM Credentials for SQL Server Source Endpoint

[nabeelaslam1994]

Hello,

I wanted to check if there is a way to perform NTLM authentication when connection to SQL Server source database in Qlik Replicate? Can we define a parameter to authorize the credentials as NTLM type?

Thanks,

Nabeel

[sureshkumar]

Hello @nabeelaslam1994 

As of now in Qlik Replicate connecting to SQL Server endpoint uses two modes of Authentication i.e Windows Authentication and SQL Server Authentication
Setting general connection properties #Setting general connection properties | Qlik Replicate Help

A Windows-based Qlik Replicate UI Server service which offers granular user authorization based on a user’s Active Directory identity and group membership.

Regards,

Suresh

[nabeelaslam1994]

Could you please provide an example on this? 

A Windows-based Qlik Replicate UI Server service which offers granular user authorization based on a user’s Active Directory identity and group membership.

@sureshkumar 

Thanks,

Nabeel

[SwathiPulagam · Accepted solution]

Hi @nabeelaslam1994 ,

Please follow the below article to change the NTLM settings on the client side and there is no way to change it from Replicate UI.

https://community.progress.com/s/article/Does-ODBC-SQL-Server-driver-expose-NTLMV1-NTLMV2-authentica...

Thanks,

Swathi