Database Authentication Error When Publishing to Gallery

[MichaelAd]

Environment Details

Publishing to Gallery fails with a database authentication error. However, the workflow runs fine in Designer. Example error message:

Error SQLDriverConnect: [Simba][ThriftExtension] (2) Error occurred during authentication.

• Alteryx Server
  • All
• Access to supported Database
• Database driver

Cause

Diagnosis
There are a variety of root causes for database authentication issues. This articles covers the usage of Saved Data Connections also known as Aliases in Designer and it applies when changes to the database connection information. A common example would be a change of the database password . The workflow runs fine in Designer, but errors when publishing to gallery. 

To exclude other issues please go through the below diagnosis steps.

• Confirm you are using a Saved Data Connection. This can be checked following the steps in the KB article How To: Tell a Database connection type at a glance.
• Confirm use Allow User Alias to override the System Alias is checked in Alteryx System Settings > Engine > General
• Confirm Run As User or Workflow Credentials are being used. See also KB Article - How Workflow Credentials Work on Private Gallery . 

If the above are met:

• Then the UserAlias is overwriting the SystemAlias
• Determine the User that is overwriting the SystemAlias. This can be done using the above mentioned KB article .
• Check that the UserAlias.xml file contains the same connection as the SystemAlias. The UserAlias.xml files can be found under %APPDATA%\Alteryx\Engine\UserAlias.xml. Make sure to check the UserAlias.xml file of the Run As User or Workflow Credentials User. Check whether the same database connection as in the SystemAlias also exists in it. It can be found in the AliasId tag.  

Resolution

 

• Remove the UserAlias.xml file of the user identified above.
• If this does not solve the issue feel free to reach out to Alteryx Customer Support .

Additional Resources

• How Workflow Credentials Work on Private Gallery
• How To: Tell a Database connection type at a glance.