KNOWLEDGE BASE

Error "Failed to authenticate the user 'username' in Active Directory (Authentication option is 'ActiveDirectoryPassword')" When Connecting to Azure SQL Data Warehouse from Tableau Cloud


Published: 19 May 2020
Last Modified Date: 08 Jul 2022

Issue

When connecting to Azure SQL Data Warehouse from Tableau Cloud using the "Active Directory Password" as the authentication type, the following error occurs:

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Failed to authenticate the user 'username' in Active Directory (Authentication option is 'ActiveDirectoryPassword').
Error code 0xA190; state 41360
AADSTS50126: Error validating credentials due to invalid username or password.

Environment

  • Tableau Cloud
  • Azure SQL Data Warehouse

Resolution

As a workaround, use the "Username and Password" authentication type for the connection to Azure SQL Data Warehouse. 

Cause

This issue is currently being investigated by Tableau Development team.
Did this article resolve the issue?