Internal Error SQLDriverConnect: [Microsoft][ODBC Driver 17 for SQL Server]

system32

Issue:

Workflow is working running in local machine/designer, but I am getting issue when saving it to Alteryx Galler/Server

Internal Error SQLDriverConnect: [Microsoft][ODBC Driver 17 for SQL Server]An unknown error has occured. Detailed error information is not available.

ODBC driver and  Connection Name were already set-up in the Alteryx Server but still getting the same error message, not sure if I missed something to configure in the gallery admin. 

"Azure Active Direction Integrated authentication" was selected in the ODBC settings. Tested the connection without any issue during setting-up the ODBC Data Source.

ODBC Error.png

Chaoued

@system32 

1- Check the Run-As Account on Alteryx Server

Go to Alteryx System Settings → Gallery → Credentials.
Ensure the Run As account is set to a domain account that has access to the SQL Server.
If it’s set to Local System, AAD Integrated authentication will fail because the server cannot impersonate your local user.

else 

2- Verify ODBC DSN Configuration

The DSN on the server must match the one used locally (same name, same driver).
Confirm that the DSN uses Authentication = ActiveDirectoryIntegrated.
If you used a User DSN locally, switch to a System DSN on the server.

AND test on the Alteryx Server, run

odbcconf /a {CONFIGSYSDSN "ODBC Driver 17 for SQL Server" "DSN=YourDSNName|Authentication=ActiveDirectoryIntegrated"}