topic SQL server as a target -ODBC Driver in Qlik Replicate

SQL server as a target -ODBC Driver

MrunalsinhP — Thu, 18 Apr 2024 06:57:36 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

Mrunal

Re: SQL server as a target -ODBC Driver

SushilKumar — Thu, 18 Apr 2024 07:28:34 GMT

Hello @MrunalsinhP

Are you using CA to connect with Endpoints. Request you to Check whether you are able to connect with Endpoints without using Qr.

Requests you to check with Self signed certificate to identify SSL certificate issue .by following below link.

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

Regards,

Sushil Kumar

Re: SQL server as a target -ODBC Driver

Heinvandenheuvel — Thu, 18 Apr 2024 15:04:58 GMT

@MrunalsinhP - are you t5he same person as, or work in the same organization as @Megha_More

Please focus all this still in a single topic !!! Delete the rest.

Hein.