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!
Are you getting this error in the ODBC Admin manager? If so, please contact IT to set up the correct driver and DSN.
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.