topic Re: MS-CDC configuration in Qlik Replicate

MS-CDC configuration

yzh — Thu, 08 Jun 2023 01:54:36 GMT

Our replicate is installed on a Windows server.

Our odbc has configured windows NT authentication login as follows:

Microsoft SQL Server ODBC Driver Version 10.00.14393

Data Source Name: PNR
Data Source Description:
Server: CNZHAUWSQL140
Database: DB_PNR_PRD
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

We test data source is succeeded,The screenshot is as follows:

But test connection failed in source endpoint.

I would like to know how to configure NT login and how to specify a configured odbc version in the provider.

Re: MS-CDC configuration

john_wang — Thu, 08 Jun 2023 02:48:44 GMT

Hello @yzh ,

Welcome to the community!

Not very sure what's the backend SQL Server database, please check the support matrix to make sure it's in the support versions range.

And, Replicate requires higher versions ODBC Driver, in Replicate 2022.11, 64-bit Microsoft ODBC Driver 18.1 for Windows is required.

Hope this helps.

Regards,

John.

Re: MS-CDC configuration

SachinB — Thu, 08 Jun 2023 02:50:44 GMT

Hello @yzh ,

When using NT authentication, SQL Server validates the user's credentials against the Windows Security Accounts Manager (SAM) database or an Active Directory domain controller. Did you try to connect using the windows' authentication instead of username and password, was it able to connect successfully?

We would, might need repsrv logs in enhanced way, So that we can check more in details.

We would prefer you to create a support ticket and will work on this. Before doing test connection, kindly set all server parameters in verbose and send us repsrv logs for further investigation.

Regards,

Sachin B

Re: MS-CDC configuration

yzh — Thu, 08 Jun 2023 06:50:28 GMT

Our Replicate version is 2022.5.0.499.Sqlserver ODBC version is 17.2.0.1.I have added sqlserver configuration to the ODBC data source and can connect to it. How to specify the added odbc name in replicate.

Re: MS-CDC configuration

john_wang — Thu, 08 Jun 2023 08:07:39 GMT

Hello @yzh ,

Thanks for the update.

I'm not sure what's design however there are different endpoint can be used to connect to SQL Server for CDC tasks. If you are intending use "Microsoft SQL Server (MS-CDC)" endpoint, as a good start Server IP or Hostname, and database name is good enough (use the default settings). A sample:

In general you need not use the ODBC DSN unless it's recommended by Qlik Support and/or Account Manager.

Regards,

John.

Re: MS-CDC configuration

yzh — Thu, 08 Jun 2023 08:27:27 GMT

Thank you for your answer. I have reconfigured it and did not use DSN. However, I need to log in using Windows NT authentication. Selecting the database reported an error. Could you please advise me on how to configure it.Thanks.

Re: MS-CDC configuration

Steve_Nguyen — Thu, 08 Jun 2023 13:33:59 GMT

you to use windows authentication , the Replicate Server need to be change to the same user as for the Windows authentication :

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_Work_with_Windows_Authentication.htm