Error: Failed to connect to SQL Server EndPoint. Failed to load 'SQL Server Native Client 11.0'

[mwallman]

Hola,

Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'..

• SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'.,Error Initializing endpoint. Failed to load 'SQL Server Native Client 11.0' Cannot load <sqlncli11.dll, >: The operation completed successfully. Cannot load <sqlncli11.dll>: The specified module could not be found.

We have ensured the SQL Server Native Client 11.0 is installed from here https://www.microsoft.com/en-sg/download/details.aspx?id=36434

We can see the sqlncli11.dll file in the C:\Windows\WinSxS\amd64... folder.

Anybody know how to solve this error please?

[suvbin]

But am unable to find at my end. Below is the screen shot.

[john_wang]

Thank you @suvbin , no problem at all.

[ramu123]

Hi Steve,

I already open a thread regarding this problem: https://community.qlik.com/t5/Qlik-Replicate/Failed-to-connect-SYS-GENERAL-EXCEPTION-Failed-to-conne...

Below error is I'm getting in Qlik replicate:

Creating Metadata Manager's utility components failed
Cannot create the source utility component
Failed while preparing stream component 'ER3 SAP ISU AOG'.
Failed to connect
RetCode: SQL_ERROR SqlState: 08001 NativeError: 10061 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.

Could you help me what could be the reason.

Thanks

Ramu.

[Dana_Baldwin]

Hi @ramu123 

This error points to a firewall issue or that there are no services listening on the configured port. Please see this link for more help:

c# - No connection could be made because the target machine actively refused it? - Stack Overflow

Thanks,

Dana

[john_wang]

---

Replicate current versions do not support SQL Server 2022 as source yet. You may run lower version SQL Server eg SQL Server 2019/2017/2016/2014 etc.

---

UPDATE:

Qlik Replicate has been certified to support SQL Server 2022 as source endpoint in below major versions:

Qlik Replicate 2023.5 (SQL Server 2014, 2016, 2017, 2019, and 2022)

Qlik Replicate 2023.11 (SQL Server 2014, 2016, 2017, 2019, and 2022)

Qlik Replicate 2024.5 (SQL Server 2016, 2017, 2019, and 2022)

Regards,

John.