Could not connect to SQL Server suddenly

[TLX-QlikView]

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

[abhijitnalekar]

Hi @TLX-QlikView ,

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

[botbiio · Accepted solution]

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

[Albert_Candelario]

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

[TLX-QlikView]

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

[Albert_Candelario]

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

[TLX-QlikView · Accepted solution]

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