Alteryx Server

Definitive answers from Server experts.

Database Authentication Error When Publishing to Gallery

Alteryx
Alteryx
Created

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