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?

[Steve_Nguyen]

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 ?

[john_wang]

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.

[mwallman]

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.

[john_wang]

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

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

[mwallman]

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)

[mwallman]

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)

[l9phan1]

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.

[PGN]

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

[john_wang]

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.