Loading

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

Дата публикации: Feb 24, 2026
Описание

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.

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.

Please note: The Driver version specified may show a different number.

Решение

To troubleshoot this issue, try to connect to the same database from Excel by following the steps in Connect Excel to an Azure SQL database and create a report, up to Step 5.

If you are unable to obtain the list of tables or views in Step 5 please follow these steps:

  1. Go to the Azure portal.
  2. Click SQL servers.
  3. Click your server name.
  4. Click Settings > Firewall.
  5. Add your Client IP address. See Azure SQL Database and SQL Data Warehouse firewall rules for details.
Дополнительные ресурсы
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.
Номер статьи базы знаний

001471264

 
Загрузка
Salesforce Help | Article