topic Re: Using NTLM Credentials for SQL Server Source Endpoint in Qlik Replicate

Using NTLM Credentials for SQL Server Source Endpoint

nabeelaslam1994 — Fri, 16 Jun 2023 13:21:07 GMT

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

Re: Using NTLM Credentials for SQL Server Source Endpoint

sureshkumar — Sat, 17 Jun 2023 03:39:45 GMT

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

Re: Using NTLM Credentials for SQL Server Source Endpoint

nabeelaslam1994 — Tue, 20 Jun 2023 12:24:15 GMT

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

Re: Using NTLM Credentials for SQL Server Source Endpoint

SwathiPulagam — Tue, 20 Jun 2023 21:20:13 GMT

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-authentication-Support-for-Multiple-Users-on-the-Windows-platform

Thanks,

Swathi