topic Error: Failed to connect to SQL Server EndPoint. Failed to load 'SQL Server Native Client 11.0' in Qlik Replicate

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

mwallman — Thu, 13 Aug 2020 16:41:38 GMT

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?

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

Steve_Nguyen — Thu, 13 Aug 2020 17:56:34 GMT

1. if you install the SQL client after Replicate you would need to restart the Replicate Services.

2. if after restart of the Replicate Service and you still have problem.

- can you test using the Windows ODBC connection on the Replicate server to see if you can connect to your SQL DB ?

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

john_wang — Fri, 14 Aug 2020 00:23:30 GMT

I think @Steve_Nguyen is giving a very good way to troubleshoot the issue.

BTW, this problem is common if you have more than Native Client installed (certainly different versions, eg one copy is v10, another one , v11). Remove the old version if this is the reason (make sure it's not used by other apps).

If you still have problem, try to reboot the OS ,or maybe we have other options eg use "Microsoft ODBC Driver 17.4.2". let us know if you need futuer assistance. And, it's better you can attach repsrv.log for our ananlysis.

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

mwallman — Fri, 14 Aug 2020 17:24:21 GMT

Hi @Steve_Nguyen and @john_wang

Thank you for the suggestions! What a nice helpful forum this is.

@john_wang - How can I check if another version of the Native Client is installed? From the Add/Remove Programs I can see v11 as I installed it but not sure how to check for another version. Is there a place that lists all?

@Steve_Nguyen- I did restart the services however that did not solve the issue. Will try the Windows ODBC connection way.

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

john_wang — Sat, 15 Aug 2020 02:11:55 GMT

Hi @mwallman Good morning,

Yes, you can know that from Control Pannel , "Add/Remove Programs".

I did not see any screen shot from your env - Please make sure you are installing/using 64-bit Client as Replicate is 64-bit app so it only can work with 64-bit Native Client.

Hold on ... seems you are using a wrong link! Replicate need the Native Client which installation file name is "sqlncli.msi", you can get it directly from MS:

http://download.microsoft.com/download/4/B/1/4B1E9B0E-A4F3-4715-B417-31C82302A70A/ENU/x64/sqlncli.msi

or download the bigger one (4.8M, there are 2 "sqlncli.msi" one is 32-bit and another 64-bit) you need the 64-bit:

http://www.microsoft.com/en-us/download/details.aspx?id=35580

(The 2 above links will download the same file for you)

I think I found the real reason now. Good luck,

have a nice day

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

mwallman — Mon, 17 Aug 2020 10:19:57 GMT

Hi @Steve_Nguyen and @john_wang

Thank you I installed the correct driver.

However now I get the following error, any indication on where the issue is please? :

[AT_GLOBAL	]I:	Attunity Replicate Server Log (V6.5.0.581 ukgiaa-temp-att Microsoft Windows Server 2012 (build 9200) 64-bit, PID: 5128) started at Mon Aug 17 09:09:06 2020 (at_logger.c:2627)
[AT_GLOBAL	]I:	Licensed to Attunity, evaluation license (45 days remaining), all sources, all targets, all hosts (at_logger.c:2630)
[SERVER	]I:	Client session (ID 1461986067) allocated (dispatcher.c:274)
[REST_SERVER	]I:	Agent was started successfully (listening on port 3552). (atctl_serve.c:399)
[SERVER	]I:	ODBC driver 'SQL Server' found as installed. (sqlserver_endpoint_util.c:361)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[AT_GLOBAL	]I:	Attunity Replicate Server Log (V6.5.0.581 ukgiaa-temp-att Microsoft Windows Server 2012 (build 9200) 64-bit, PID: 5128) started at Mon Aug 17 09:09:06 2020 (at_logger.c:2627)
[AT_GLOBAL	]I:	Licensed to Attunity, evaluation license (45 days remaining), all sources, all targets, all hosts (at_logger.c:2630)
[SERVER	]I:	Client session (ID 1461986067) allocated (dispatcher.c:274)
[REST_SERVER	]I:	Agent was started successfully (listening on port 3552). (atctl_serve.c:399)
[SERVER	]I:	ODBC driver 'SQL Server' found as installed. (sqlserver_endpoint_util.c:361)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)

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

mwallman — Mon, 17 Aug 2020 10:59:44 GMT

Hi @john_wang and @Steve_Nguyen

Any idea how to resolve this error? Gracias for the information, we get the following error when connecting. We also tried ODBC way but unsuccessful.

[AT_GLOBAL	]I:	Attunity Replicate Server Log (V6.5.0.581 ukgiaa-temp-att Microsoft Windows Server 2012 (build 9200) 64-bit, PID: 5128) started at Mon Aug 17 09:09:06 2020 (at_logger.c:2627)
[AT_GLOBAL	]I:	Licensed to Attunity, evaluation license (45 days remaining), all sources, all targets, all hosts (at_logger.c:2630)
[SERVER	]I:	Client session (ID 1461986067) allocated (dispatcher.c:274)
[REST_SERVER	]I:	Agent was started successfully (listening on port 3552). (atctl_serve.c:399)
[SERVER	]I:	ODBC driver 'SQL Server' found as installed. (sqlserver_endpoint_util.c:361)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)
[SERVER	]I:	Source endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:740)
[SERVER	]E:	RetCode: SQL_ERROR SqlState: HY000 NativeError: 40532 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open server "jurate.windows.net" requested by the login. The login failed. [1022502] (ar_odbc_conn.c:561)
[SERVER	]E:	Failed to connect [1022502] (sqlserver_endpoint_imp.c:2051)

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

l9phan1 — Mon, 17 Aug 2020 12:28:44 GMT

Did you try to login from the Qlik Replicate server to the SQL server using SSIS? Basically validate the username/password for login to SQL server is ok.

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

PGN — Mon, 17 Aug 2020 16:44:44 GMT

Does the service account have permissions on the server and database you're trying to connect to?

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

john_wang — Tue, 18 Aug 2020 03:33:35 GMT

This is a network issue. You need your DBA help, or there are many articles about this error in internet, I did not get it too much in the past. If you manage to solve it , please share your solution to us.

thanks.

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

suvbin — Mon, 27 Feb 2023 07:10:41 GMT

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.

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

john_wang — Mon, 27 Feb 2023 08:28:26 GMT

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.

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

suvbin — Mon, 27 Feb 2023 09:19:31 GMT

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

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

john_wang — Mon, 27 Feb 2023 09:47:22 GMT

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.

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

suvbin — Mon, 27 Feb 2023 09:53:32 GMT

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.

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

john_wang — Mon, 27 Feb 2023 09:59:16 GMT

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.

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

suvbin — Tue, 28 Feb 2023 06:54:59 GMT

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

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

john_wang — Tue, 28 Feb 2023 06:58:30 GMT

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

thank you,

John.

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

suvbin — Wed, 01 Mar 2023 06:15:57 GMT

hi john, there is no option to accept the solution

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

john_wang — Wed, 01 Mar 2023 08:24:28 GMT

Hi @suvbin ,

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

Regards,

John.