topic SQL Server Target issue in Qlik Replicate

SQL Server Target issue

Megha_More — Thu, 18 Apr 2024 07:11:07 GMT

Hi Team

We are getting below error in a task.

Could you please help us with the same.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot connect to SQL Serv
Ret Code: SQL_ERRO SqlState:08001 Native Error:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.

Regards,

Megha

Re: SQL Server Target issue

Megha_More — Thu, 18 Apr 2024 07:31:40 GMT

Hi Team,

Due to a technical glitch, the question was marked as spam initially, leading to multiple reposts. I sincerely apologize for any inconvenience caused by this oversight.

I kindly request your understanding and would appreciate it if you could disregard the duplicate posts and focus solely on this message.

Regards,
Megha

Re: SQL Server Target issue

DesmondWOO — Thu, 18 Apr 2024 07:58:25 GMT

Hi @Megha_More ,

Can you test the certificate successfully via the ODBC DSN?

Regards,
Desmond