topic SQL Server as target in Qlik Replicate

SQL Server as target

Megha_More — Thu, 18 Apr 2024 07:00:48 GMT

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

Re: SQL Server as target

SushilKumar — Thu, 18 Apr 2024 07:30:37 GMT

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

Re: SQL Server as target

Megha_More — Thu, 18 Apr 2024 07:39:00 GMT

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

Re: SQL Server as target

Megha_More — Thu, 18 Apr 2024 07:42:15 GMT

Hello Team,

Issue is not resolved yet!

Regards,

Megha

Re: SQL Server as target

DesmondWOO — Thu, 18 Apr 2024 07:56:44 GMT

Hi @Megha_More ,

Can you test the certificate successfully through the ODBC DSN?

Regards,
Desmond

Re: SQL Server as target

Heinvandenheuvel — Thu, 18 Apr 2024 15:01:49 GMT

@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.