In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Cannot connect to Microsoft Azure SQL Database - ODBC Driver Issue

Eulogitos
5 - Atom

Hello,

 

I am trying to connect to Microsoft Azure SQL Database using ODBC;however, I am always getting the same error: 

 

Error: Output Data (11): Error SQLDriverConnect: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '' in Active Directory (Authentication option is 'ActiveDirectoryIntegrated').
Error code 0xCAA9003C; state 10 ADAL received an empty response from the server during a WIA flow and could not continue.

 

I have updated the ODBC drivers and also tried ODBC 14, 17 and 18, buth with no luck.

 

Could anyone point to the right direction please?


Thanks!

 

 

2 REPLIES 2
gabrielvilella
14 - Magnetar

Are you getting this error in the ODBC Admin manager? If so, please contact IT to set up the correct driver and DSN.

jNunez
8 - Asteroid

It seems like the Azure SQL server may not be registered to your AD domain. This is definitely something IT will have to look at.