topic Re: Could not connect to SQL Server suddenly in Data Movement & Streaming

Could not connect to SQL Server suddenly

TLX-QlikView — Wed, 19 Mar 2025 23:02:17 GMT

Hi all

We have 10-15 apps connecting to SQL Server hosted in qlik cloud. Till today, we were able to connect to sql server

From yesterday, all the connections failed. Error just says "Connection failed, Check Username, password, host and other properties"

No changes made on the database end

Please help out

REgards

KRS

Re: Could not connect to SQL Server suddenly

abhijitnalekar — Fri, 18 Aug 2023 07:52:25 GMT

Hi @TLX-QlikView ,

Please check with your DBA. It must be password gets expired.

Re: Could not connect to SQL Server suddenly

botbiio — Fri, 18 Aug 2023 16:37:12 GMT

please check this thread, hope it helps
Outdated, out of support versions of Microsoft SQL... - Qlik Community - 2093595

Re: Could not connect to SQL Server suddenly

Albert_Candelario — Sat, 19 Aug 2023 08:26:47 GMT

Hello all,

Kindly ensure you are not using SQL server 2012 neither Windows Server 2012R2 and also ensure TLS 1.2 is enabled.

Cheers,

Albert

Re: Could not connect to SQL Server suddenly

TLX-QlikView — Mon, 21 Aug 2023 10:52:49 GMT

We are using SQL Server 2014. Still could not connect to.

Also, how can we check that SQL Server connection is using TLS 1.1 or 1.2

Thanks

KRS

Re: Could not connect to SQL Server suddenly

Albert_Candelario — Mon, 21 Aug 2023 12:46:22 GMT

Hello @TLX-QlikView,

You can also disable the week chipers:

Disabling Weak Cipher suites for TLS 1.2 on a Wind... - Qlik Community - 1716891

You can disable it using this tool for example:

https://www.nartac.com/Products/IISCrypto

Cheers,

Albert

Re: Could not connect to SQL Server suddenly

TLX-QlikView — Thu, 24 Aug 2023 08:06:47 GMT

hi all,

As update for the question, though we had SQL Server 2014, it was running on windows 2012 and hence count not connect.

We could not update the existing TLS or security setup. As an alternate, we setup a data gateway in another server and using that we connected to the SQL Server.

Thanks for the support

KRS