SQL Server Target issue

[Megha_More]

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

[Megha_More]

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

[DesmondWOO]

Hi @Megha_More ,

Can you test the certificate successfully via the ODBC DSN?

Regards,
Desmond