Skip to main content

TX: 20.10.39

SQL Server: 2019

Endpoint settings:

  • Windows authentication
  • hostname matching case
  • https connection over the default proxy

 

I am trying to push a Qlik Sense Enterprise endpoint from TimeXtender and having trouble getting the deploy successfully running. Testing connection to Qlik Sense is successful, when I Deploy I get an error when TX tries to create a new Data Connection.

 

I see this issue pop up sometimes in other deployments and can usually overcome by manually making a Data Connection to the MDW database and giving it the same name TX would use: MDW_SLQV . In this case, I get the same error when TX tries to modify the connection.

TimeXtender does create the app (and is owner of it) and can successfully reload the app, it just doesn't insert the script. If I copy-paste the TX Qlik Script into the app it works fine. As neither TX nor Qlik actually log what is going on, I cannot see what about the connection string is causing the error.

@rory.smith can you please try installing this provider on the Qlik server?


OK, I am not sure if this was not already done - will need to get permission to do that.


Hi @Christian Hauggaard ,

 

just to let you know: the 19.3 version of the provider requires the 2022 C++ Redistributable for Visual Studio, but has problems with actually detecting this is installed. See also the comments: https://techcommunity.microsoft.com/t5/sql-server-blog/ole-db-driver-19-3-for-sql-server-released/ba-p/3742786

We installed 19.2 to avoid this error and successfully installed the driver. Now we get a “Connection to the server could not be established” connection error asking to check the network ports (this was working fine before) when trying Test Connection on the Qlik Sense server or when Deploying and Executing the endpoint I have verified that the port setup in Qlik is the default and that both port 80 and 443 (and the other Qlik ports) are reachable through Test-Netconnection. 


I switched to certificate authentication which got the connection to the Qlik Sense server working again, but now we get the original “cannot modify the connection something is wrong with the connection string” error again. It looks like installing the driver did not solve the underlying issue.


Also: installing the driver (and / or the C++ Redistributable for Visual Studio 2022) ended up making the Qlik Sense server no longer respond to requests coming from outside the server, so we had to revert to a previous state.


Hi @rory.smith do you have time for a screen share today sometime between 8.30-10 or 11-12 or 13.30-15 CET?


Hi Christian,

 

I won't be able to access this customer's system, but luckily our own system suffers from the same problem. Would 11:00 CET work for you?


@rory.smith yes, I have sent you an invite now :)


Thanks for the call @rory.smith, we were able to deploy successfully after installing version 18.2.3 of the Microsoft OLE DB Driver for SQL Server on the Qlik Server (instead of version 19.x). Another note that was made during the call, is that it is only for SQL Server 19 that requires this driver to be installed

 


Reply