Welcome to the Alteryx Knowledge Base

We have groups migrating to Azure SQL Servers and are trying to configure the connection in Alteryx Gallery. To begin this testing, we are attempting to connect on the Server's Designer instance, but the connection errors out because it is not passing on the credentials. This occurs only in Gallery, the workflows using the same connection and authentication type run successfully in Designer on Server and at end-user laptops

Testing in the DSNs ODBC shows a successful authentication / connection

Error SQLDriverConnect: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '###' in Active Directory (Authentication option is 'ActiveDirectoryPassword'). Error code 0xCAA82EE2; state 10 The request 

• Alteryx Server 2021.1
• Microsoft Azure SQL
• MS ODBC SQL version 17.10.0005 / 18
  • Azure Active Directory with Password Authentication

• This error usually occurs when workflows are not published to Server specifying that user credentials are required to run, causing the workflow to fail to authenticate to the datasource by using the RunAs user.
• This error may occur if the access to the Azure Active Directory (AAD) is blocked by your proxy or firewall.

• Reachout to your IIT to confirm and resolve any firewall rules preventing AAD access
• Ensure that server credential settings is set to Allow User to Select, to give user the ability to publish workflows specifying that credentials are Required for the workflow

• For Azure SQL Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.
• https://knowledge.alteryx.com/index/s/article/Troubleshooting-Entering-credentials-has-been-disabled-Credential-usage-is-disabled-1583461566617
• https://knowledge.alteryx.com/index/s/article/Troubleshooting-Unable-to-save-Workflow-Credentials-1583461566697