Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:15:54 PM
May 10, 2021 11:03:14 AM
Qlik Sense Enterprise on Windows
Microsoft SQL Server
Upgrade of Qlik Sense fails when you try to install Qlik Sense on a computer where:
The installation fails with the following symptoms:
Unable to make a connection to the database server.
SQL::connect to server <SQL server name>
Testing NT Authentication to SQL Server.
Failed to connect to SQL Server [<SQL server name>] with error code [0x80004005]
Description for error code is [TCP Provider: An existing connection was forcibly closed by the remote host.]
Failed in connectToSQLServer with error code [0].
Where <SQL_Server_Name> is the name of the SQL Server being used.
Qlik Sense stops functioning, even after it was successfully installed on a computer, where:
Qlik Sense uses the SQL 2012 Native Client to make connections to SQL. When the client is not present at the time that Qlik Sense is installed, the Qlik Sense installer installs the correct version. But, if an existing version with a lower minor version number is installed, the Qlik Sense installer does not upgrade it.
If the previously installed version only supports TLS 1.0, Qlik Sense is unable to connect to an SQL Server that has TLS 1.0 disabled. This fact can cause the following problems:
The solution to both these problems is the same. You must upgrade the SQL 2012 Native Client on the Qlik Sense server to a version that supports TLS 1.2.