topic Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec in Qlik Replicate

In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,Re

ramu123 — Mon, 12 Jun 2023 10:50:58 GMT

Hi All,

I would like to change my qlik replicate connection to source database(MS sql server), but I'm unable to connect to source database and I'm getting this error message. I tried with other test and pre-prod environments but I'm getting same error.

SYS-E-HTTPFAIL, Failed to connect.
SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 08001 NativeError: 258 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out.

Could you please share your suggestions

Thanks

Ramu

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Fail...

Steve_Nguyen — Mon, 12 Jun 2023 13:56:19 GMT

@ramu123 where is the Replicate server, on a windows server or Linux server ?

on the Replicate server, outside of Replicate are you able to connect to the SQL server ?

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Fail...

ramu123 — Thu, 15 Jun 2023 09:04:37 GMT

Hi Steve,

After Vnet peering is done, I'm able to connect to source DB. Thanks for your suggestion.

Thanks

Ramu

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec

MoeE — Fri, 18 Oct 2024 04:37:57 GMT

Hi Ramu,

We are experiencing the same issue. Can you by any chance elaborate on what was done to fix the issue?

Regards,

Mohammed

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec

john_wang — Fri, 18 Oct 2024 05:00:47 GMT

Hello Mohammed, @MoeE

Not sure what's the Replicate version and SQL Server version, however I do not think ODBC Driver 17 is a better one, we support ODBC Driver 18 (please check UG for detailed version number).

BTW, how about the 64-bit ODBC DSN, does it work?

thanks,

John.

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec

Kent_Feng — Fri, 18 Oct 2024 05:12:17 GMT

Hi @MoeE

It looks like the issue was due to networking reasons and Ramu fixe it by allowing the Replicate Server VM and SQL Server VM to talk to each other.

Thanks

Kent

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec

MoeE — Tue, 05 Nov 2024 01:40:26 GMT

Hi @Kent_Feng, @john_wang,

For informational purposes in case someone has this issue in the future. Our case was due to the connection string being incorrect for a high availability cluster. Also, double check that your user still has the necessary permissions in each DB/node in the cluster.

Regards,

Mohammmed

Re: In qlik replicate, Unable to connect to source database(MS sql server):- SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connec

john_wang — Tue, 05 Nov 2024 01:42:54 GMT

Thank you so much for your amazing support! Mohammed @MoeE