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]

Hi, 

while trying to connect to SQL server as a source , am getting the following error. 

"unexpected error/database version 0". 

replicate version 2022.11 version (installed in the desktop)

sql server version 16.0.10 (installed in the desktop)

Please suggest. Please let me know if anyother information required.

[john_wang · Accepted solution]

Hello @suvbin ,

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.

Regards,

John.

[suvbin]

Qlik replicate version is 2022.11 version,  and SQL server vesion is 16. Please find the screenshot of the same .

[john_wang]

Hello @suvbin ,

Let's change a way - If you run SQL

select @@version

Typical results looks like:

Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 ...

Where 16.x is Microsoft internal ProductVersion In general we do not call it.

Regards,

John.

[suvbin]

ok ....  got it. so 16.x is not the sql version. 

if possible could you please share the link for sqlserver to download.

Appreciate  your help.

Thanks in advance.

[john_wang]

Hello @suvbin ,

Microsoft SQL Server is not Qlik Products, we do not distribute non-Qlik software. You may contact Microsoft for download links.

Regards,

John.

[suvbin]

Thank you john for your support. The issue got resolved. 

[john_wang]

Glad to hear that, @suvbin . Please click "Accept as Solution" if it helps.

thank you,

John.

[suvbin]

hi john, there is no option to accept the solution 

[john_wang]

Hi @suvbin ,

No worries. It can be found at the right of the page:

Regards,

John.