Loading

Error: "Could not connect to server" When using the "Test Connection" Option on Tableau Server With MSSQL Impersonation

Дата публикации: Mar 28, 2025
Описание
When testing a connection to a published data source on Tableau Server, the following error might occur after clicking the "Test Connection" option: 

Could not connect to server
An internal error occurred while establishing an impersonated database connection.

Cause

SQL Server will not accept an Active Directory (AD) username and password passed from a separate AD user account. 

Typically, "Test Connection" will function because it creates a direct connection to the database and does not involve the Run As User service account. However in this case, "Test Connection" is attempting to validate the user signed into Tableau Server instead of the Run As User. If this user does not have connect permissions, using the "Test Connection" option will fail. 

When Tableau Server runs a refresh or connects to SQL it will use the Tableau Server Run As user account and the connection will succeed. It is expected behavior that the Database connection will connect with the Run As User account before providing SQL Server the impersonated user's credentials through the query. 
Решение
Test the connection by connecting to the published data source using Tableau Desktop. 
Дополнительные ресурсы
For more information about SQL Server authentication, please see the following Tableau Help articles: 
Номер статьи базы знаний

001498384

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