KNOWLEDGE BASE

Error "The connection to the data source might have been lost" Connecting to Microsoft SQL Server from Tableau Server on Linux


Published: 14 Oct 2020
Last Modified Date: 04 Mar 2021

Issue

Connecting to Microsoft SQL Server from Tableau Server on Linux Ubuntu 18.04 or Debian 9 using the msodbcsql17 driver fails with an error similar to the following: 

Error: The connection to the data source might have been lost. ReadBytes: Communication with the Tableau Protocol Server process was lost. Tableau Protocol Server process might be terminated, possibly due to system resource constraints or another external source Unable to connect to the Microsoft SQL Server server (...). Check that the server is running and that you have access privileges to the requested database

Environment

  • Tableau Server 2020.1 and newer versions
  • Ubuntu 18.04 LTS
  • Debian 9
  • MS SQL Server 
  • msodbcsql 17 driver 
Did this article resolve the issue?