KNOWLEDGE BASE

Tableau Error "Error Code: 06DA155A [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection..." Connecting to Azure Synapse Analytics


Published: 28 Oct 2022
Last Modified Date: 31 Oct 2022

Issue

Can not connect to Azure Synapse Analytics server due to TCP related error below:

An error occurred while communicating with Azure Synapse Analytics
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
Error Code: 06DA155A
[Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.
[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
[Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
[Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection due to prelogin failure
Unable to connect to the Azure Synapse Analytics server "<server name or ip address>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • Tableau Server
  • Azure Synapse Analytics

Resolution

Work with your IT network team to configure the network setting to access Azure Synapse Analytics server.
Check that your firewall allows outgoing TCP communication on TCP port 1433, since the SQL Azure Database / Azure Synapse Analytics service is only available with TCP port 1433
For more troubleshooting information, please refer to the Microsoft document Azure SQL Database and Azure Synapse IP firewall rules - Troubleshoot the database firewall .
 

Cause

Environmental - Network
The "TCP" error indicates that there is a network connection issue between Tableau Desktop or Tableau Server and the Azure Synapse Analytics server.
Did this article resolve the issue?