QlikSense connexion failure with SQL query ERROR [08S01] TDSConnectionFailed

gromesp — Tue, 12 Nov 2019 16:31:16 GMT

Hi everyone!

I have attached a log generated by Qlik Sense and I will try to briefly describe the issue:

QlikSense connects to various countries' ERP and/or account systems to extract the data.
In this case, it's SAGE 100 in France.
The connection itself to the DB is fine, both us and our partners can access it run queries within in.
HOWEVER, when Qlik tries to execute the same query, the connection is terminated and outputs the following error: ERROR [08S01] TDSConnectionFailed. It's worth mentioning that it had worked flawlessly during the past year.
Another important aspect: the query executes without any issue on the development server. On LIVE, however, it fails.

So far we've tried the following:

checking for changes to the server on our side, as well as both our partners. Nothing was found.
reconfiguring the VPN tunnel for the QlikSense Live Server.
checked that there were no updates to the SQL Server Qlik Connector
compared Qlik server and DB server logs and no relevant issues were found

Hopefully you guys can lend me a hand here because at this point I'm at a loss about how to proceed with this issue.

Thanks in advance!

George

Re: QlikSense connexion failure with SQL query ERROR [08S01] TDSConnectionFailed

j_neyret — Fri, 16 Oct 2020 07:26:03 GMT

I have the same issue when connecting with QlikSense Business

The connexion with OLEDB is well running!

Can you help me ?

Thanks

J Neyret

j.neyret@aexecutive-cm.com