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

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 Jun 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.