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 Online


Published: 19 May 2020
Last Modified Date: 15 Jun 2020

Issue

When connecting to Azure SQL Data Warehouse from Tableau Online 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 Online
  • 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?