SQL Server as target

[Megha_More]

Hi Team

We are getting below error in a task.

Could you please help us with the same.

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 coonect 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

[SushilKumar]

Hello @Megha_More 

Request you to please check with self signed certificate by following below community link.

Solved: Restoring the original self-signed certificate of ... - Qlik Community - 2158552

Regards,

Sushil Kumar

[Megha_More · Accepted solution]

Hello @SushilKumar 

The post refers to replacing the SSL certificate, yet in the replicate console, the mentioned error is only affecting 3-4 tasks while the others are running smoothly.

If the issue were related to the SSL certificate, wouldn't it impact all tasks uniformly? Please let me know if my understanding is incorrect.

Best regards,

Megha

[Megha_More]

Hello Team,

Issue is not resolved yet!

Regards,

Megha

[DesmondWOO]

Hi @Megha_More ,

Can you test the certificate successfully through the ODBC DSN?

Regards,
Desmond

[Heinvandenheuvel]

@Megha_More  - can you please clean up (delete0 all those duplicate topics?!?!

Hmm, it seems to me that @SushilKumar 's answer refers to issues with the Replicate UI certificate not a target DB connection the OP asks about. @Megha_More correctly indicates that if this was relevant at all,  it would fail for all connections.

@Megha_More - The usual support question.

• Did it ever work?
• Is the target SQL server the same as the working server
• Can you export-all, and trim down the result to show the endpoint definition for a failing connection, as well as for a working one?
• This is not my area of expertise, but maybe you can look around in the endpoint "Advanced" section "Internal Parameters" - use "!" as input to see various options like "useEncryptedConnection"

Hein.