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.