I doubt if this error is on the tableau side. From the error, i feel this could be caused by SQL server stopping the queries which exceed certain time limit.
Couple of things i would check,
1) Going to log files on the server. Go the backgrounder log files which can lead us to more details information about the error.
2) I would check any timeouts on the SQL server side. You mentioned you can see the SQL issued from tableau on the db. Did the query complete?
Hope this helps.
Hi Jenner, your best bet is to open a support case with Tableau. They can look at the logs and help figure out what's going on -- whether it's an issue with SQL Server, an issue with your server configuration, or an issue with Tableau.
The query does not complete. As soon as the refresh is killed (presumably on the SQL side) the query is ended and the TDS protocol error is thrown up. I've run the exact query directly in SQL and it has succeeded and I've run it in SQL from a different VM and had no problems. It only has issues when it is run from Tableau.