Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
MrunalsinhP
Partner - Contributor III
Partner - Contributor III

SQL server as a target -ODBC Driver

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

Labels (1)
2 Replies
SushilKumar
Support
Support

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 

Heinvandenheuvel
Specialist III
Specialist III

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