KNOWLEDGE BASE

Error "An existing connection was forcibly closed by the remote host" When Connecting to Azure SQL


Published: 03 Dec 2018
Last Modified Date: 02 Jan 2019

Issue

When connecting Tableau Desktop to Microsoft Azure SQL, the following error may occur: 

[Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.
[Microsoft][ODBC Driver 13 for SQL Server]Communication link failure
Unable to connect to the server "
<servername>.database.windows.net". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • Windows 10
  • Microsoft Azure SQL

Cause

The underlying cause may be an issue with Azure SQL firewall configuration, an Azure SQL service outage, name resolution, firewall or proxy configuration, or other network problems.

Additional Information

For more information about this topic, see SQL Azure Connectivity Troubleshooting Guide.

Note: The information above is related to a third-party product. Please note that while we make every effort to keep references to third-party content accurate and up to date, the information we provide here might change without notice as the third-party product changes.
Did this article resolve the issue?