Getting error of ODBC drive-MSSQL as a target

[Megha_More]

Hi Team,

We are using MSSQL as a target. But getting error regarding ODBC drive which is already installed on replicate machine

Error:

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

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
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards,

Megha

[OritA · Accepted solution]

Hi Megha, 

It seems that the problem you are facing is since your certificate had expired (as stated in the error):

NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

To solve it please try to add the following internal parameter to the MS SQL endpoint:  useTrustServerCertificate

and stop and resume the task so that it will take into effect. If after this change the problem perists please open a case and provide the task logs with the task diagnostic package.

Thanks & Regards,

Orit

[DesmondWOO]

Hi @Megha_More ,

Please try to test your certificate through the ODBC DSN. 

Regards,
Desmond

[Megha_More]

Hi @DesmondWOO ,

We are able to test the ODBC DSN.

Regards,

Megha

[Megha_More]

Hi @OritA ,

Thank You !! Issue has been resolved after adding the internal parameter.

Regards,

Megha