article Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics in Official Support Articles

Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Wed, 11 Dec 2024 11:03:11 GMT

Qlik Cloud (Qlik Sense) is incompatible with outdated and non-supported versions of Microsoft SQL Server and cannot utilize them as a data source.

Microsoft SQL Server 2012 and earlier are not supported by Microsoft (see SQL Server lifecycle dates). If you are unclear which version of SQL Server you have, use one of the methods described in this Microsoft article.

The Qlik Cloud Analytics connector for Microsoft SQL Server officially supports versions 2014 through 2022.

To continue using the Microsoft SQL Server connector in Qlik Cloud Analytics you must ensure that your environment is on a supported Microsoft SQL Server version within a supported version of the operating system. For reference and details, review the Microsoft online documentation pages on how to upgrade SQL Server.

You also have the option to move your on-premises Microsoft SQL Server to Azure SQL Database. This cloud version uses the same database engine, which is continuously improved and upgraded in Microsoft Azure. Qlik Cloud Analytics already has a dedicated connector for Azure SQL Database.

This issue with older versions of Microsoft SQL Server is an excellent example of why Qlik recommends that sources being accessed by Qlik Cloud Analytics are kept up-to-date. Using a recent version enables you to:

Protect your data with the latest security updates. Not just within the database, but also in the protocols used in the data connection to external platforms
Take advantage of new capabilities and new features, as well as general improvements like performance
Proactively ensure compatibility with other environments and platforms when they get updated

If you are affected by this change or have any questions, please contact our Qlik Support representatives through chat.

Environment:

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

alex_carvalho — Thu, 17 Aug 2023 01:40:36 GMT

Meu SQL é versão 2016 e até hoje (16/08/23) estava funcionado até as 08hs. Depois começou a dar erro de conexão.

Esse é exemplo da conexão:

E o erro que começou a aparecer:

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

scasal — Thu, 17 Aug 2023 20:50:17 GMT

Hi, I have the same problem. We updated to SQL Server 2014 on 10th August and it was working Ok until 16th August in the morning.

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Albert_Candelario — Fri, 18 Aug 2023 09:58:46 GMT

Hello all,

Have you set up the TLS to 1.2? If yes, what was the outcome?

Bear in mind is also mentioned:
" This update will also result in no support for TLS version 1.1 and earlier as well as any deprecated cryptographic functions."

Cheers,

Albert

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Jordi — Fri, 18 Aug 2023 10:49:52 GMT

We've the same issue, with SQL Server 2014 since 08/17/2023. Tried with all TLS versions available with no success.

Any news about it?

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Rakesh_HB — Fri, 18 Aug 2023 13:23:10 GMT

Hello @Jordi ,

Please make sure that TLS 1.0, 1.1 is disabled explicitly on the server and that only TLS 1.2 is enabled on the server. Also, make sure to use TLS 1.2 in the connection.

You can check the version of TLS being used on the MSSQL side to establish the connection using an extended event and do a live monitoring of the event to check the handshake.

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

alex_carvalho — Fri, 18 Aug 2023 13:34:32 GMT

Olá Albert_Calendario, foi realizado a configuração para 1.2 sim e o resultado foi o mesmo.

A resposta que recebi da Qlik até o momento, foi que o denominador comum era que todos que tiveram esse problema estavam executando o Windows Server 2012 R2, e que um cliente mudou o servidor para Windows Server 2022 Datacenter 21H2 e seu SQL Server para Microsoft SQL Server 2019 (RTM) e que foi resolvido o problema. E qualquer novidade informariam.

Contra a vontade, mas por necessidade, mudamos o nosso servidor para o Windows Server 16 e o problema foi resolvido. A conexão foi restabelecida.

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

alex_carvalho — Fri, 18 Aug 2023 13:38:53 GMT

Olá @Rakesh_HB , todos esses procedimentos foram realizados e não tivemos sucesso. Ficamos dois dias insistindo no problema de TLS e só foi resolvido alterando o Windows Server mesmo.

Valeu

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Jordi — Fri, 18 Aug 2023 14:34:50 GMT

We are sure that server has TLS 1.0 and 1.1 disabled by default, and TLS 1.2 Enabled, althougth the connection still fails. So as @alex_carvalho said, problably the only way to solve the problem it will be upgrading server OS. But that's not explained on the "Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics" post, and its a great problem.

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

scasal — Fri, 18 Aug 2023 18:00:45 GMT

Hi, we solved the error connection, installing SP2 on the SQL Server 2014 and enabling TLS 1.2.

Cheers,

Silvia

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Albert_Candelario — Sat, 19 Aug 2023 08:32:55 GMT

Thanks for the updates and hearing the connection is working again.

Thanks for sharing it!

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

TLX-QlikView — Mon, 21 Aug 2023 11:45:10 GMT

We are facing the same problem. Could not connect to the SQL Server . We have SQL server 2014 still error

We have all TLS 1.0, 1.1, 1.2 enabled

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Mon, 21 Aug 2023 11:48:44 GMT

Hello @TLX-QlikView

Can you confirm what version of Windows the SQL server is hosted on?

All the best,
Sonja

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

TLX-QlikView — Mon, 21 Aug 2023 12:05:47 GMT

We have two servers

Microsoft Windows Server 2019 Datacenter - DB 2

Microsoft Windows Server 2012 R2 - DB 1

Both serrvers have sql 2014

We are not able to connect to both of them

Thanks

KRS

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Mon, 21 Aug 2023 12:05:49 GMT

Thank you for the feedback, @TLX-QlikView

We've recently become aware of compatibility issues caused by Windows 2012 R2 or earlier servers.

Several customers successfully update their Windows 2012 R2 server to Windows 2016 or higher, resulting in the issue being resolved. If you cannot update your Windows OS where SQL server is installed, it is suggested to use Qlik Data Transfer as an interim measure until a Windows upgrade can be performed on your Windows 2012 R2 server. Or, if possible, stand up a second temporary MSQL server on a Windows 2016 or higher server and then migrate a copy of your database(s) therein.

See:

Installing Qlik Data Transfer | Qlik Support YouTube Channel
Uploading on-premises data with Qlik DataTransfer

Please note that Microsoft (and in turn Qlik) are not going to be supporting Windows 2012 beyond Oct. 12, 2023 when it reaches 'end of life'. See Windows Server 2012 and 2012 R2 reaching end of support.

If your organization is running Windows 2012 R2 or earlier, we recommend upgrading to Windows Server 2016 or higher versions as soon as possible. Doing so will maintain a supported platform beyond Oct. 12, 2023 but also expect to resolve the the SQL connector error encountered.

We are still investigating and will update our article and documentation as soon as possible.

All the best,
Sonja

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Mon, 21 Aug 2023 12:07:50 GMT

Hello @TLX-QlikView

My original reply was to the original message in which you had mentioned only a Windows 2012 R2 instance. It applies to this.

For the Windows Server 2019 Datacenter, let me contact our subject matter experts.

All the best,
Sonja

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Mon, 21 Aug 2023 12:23:34 GMT

Hello once again, @TLX-QlikView

Regarding the Windows 2019 server: we'd need a support ticket to investigate this. When logging the ticket, please include your cipher and TLS protocol settings as per Exporting Template with IISCrypto. This will help us replicate the settings you have.

All the best,
Sonja

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

TLX-QlikView — Mon, 21 Aug 2023 12:28:20 GMT

Thanks for the update.

We are using Qlik Sense SaaS, how does Qlik Data Transfer work with it.

The link shows Data Transfer installation for Desktop vresion?

thanks

KRS

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

Sonja_Bauernfeind — Mon, 21 Aug 2023 12:47:57 GMT

Hello @TLX-QlikView

Qlik Data Transfer is meant for Qlik Cloud / Qlik Sense SaaS use. Qlik DataTransfer uploads data from on-premises data sources to Qlik Cloud. Qlik DataTransfer can provide access to on-premise data sources that are otherwise unavailable to Qlik Sense SaaS. Qlik DataTransfer also can upload data from Qlik Sense Desktop and Qlik Sense Enterprise on Windows apps to Qlik Sense SaaS.

As Qlik Data Transfer is not affected by the adjustments made, it can be used as a workaround for the time being. It is not meant to replace an upgrade to supported environments.

All the best,
Sonja

Re: Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics

TLX-QlikView — Mon, 21 Aug 2023 14:10:42 GMT

Reg. Windows 2019 , we were able to connect to the SQL Server Connector. No issues with it.

For Windows 2012 Server, i will try out the Data transfer option and update the results here.

Thanks

KRS