Cannot connect to Microsoft Azure SQL Database - ODBC Driver Issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you getting this error in the ODBC Admin manager? If so, please contact IT to set up the correct driver and DSN.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
