Azure SQL Database
An Azure relational database service.
6,319 questions
Can connect with database using Azure Studio not with ODBC
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hamish HFL
5
Reputation points
Please provide the following details to your technical contact:
- Error Details: The exact error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '******@highlandfarms.net' in Entra ID (Authentication option is 'ActiveDirectoryInteractive'). Error code 0x534; state 11.
- Setup Overview: The database PWYBE on server pwybe.database.windows.net is an Azure SQL Database with AAD-only authentication, configured with ******@highlandfarms.net as the admin. The user was created with db_owner permissions, and firewall rules include the client IP.
- Past Attempts: Previous ODBC tests failed with similar authentication errors, despite verifying admin rights and adjusting connection policies and firewall settings. Registry changes and independent tests were attempted without success.
- Current Environment: Using ODBC Driver 18.05.0001, Windows ODBC Data Source Administrator, and a DSN targeting PWYBE.
- Additional Context: The same credentials (******@highlandfarms.net) were successfully used to access SSMS, SSMA, Azure Data Studio, Visual Studio Code, and Power BI with no issues, suggesting the problem is specific to the ODBC configuration or driver.
- Suspected Issues: Possible local firewall block on port 1433, AAD credential or MFA issue, or Azure configuration mismatch specific to the ODBC driver.
- Request: Assistance in diagnosing the AAD authentication failure, checking network connectivity (port 1433), and validating the ODBC setup. Suggest testing with SSMS or Azure Data Studio using the same credentials for comparison to isolate the issue.
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator2025-06-19T17:37:23.1833333+00:00 Hi @ Hamish HFL
Greetings!!!
From the error you're seeing (
0x534; state 11), it looks like the ODBC driver is having trouble completing the Azure AD interactive login, even though your credentials work fine in tools like SSMS and Power BI.Here are a few key things to check:
Make sure port 1433 is open on your network/firewall — ODBC needs this to connect to Azure SQL.
Double-check your DSN setup to ensure it includes:
Authentication=ActiveDirectoryInteractiveUpdate your ODBC Driver to the latest version (18.7 or newer) — older versions may not fully support all AAD features.
Ensure MSAL is installed (used for AAD interactive login prompts).
Try running the test using the 64-bit or 32-bit version of odbcad32.exe depending on your app.
Since other tools are working with the same credentials, the issue seems specific to how the ODBC driver is handling the AAD login — likely a setup, network, or version issue.
Hope this helps. Do let us know if you any further queries.
-
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
2025-06-20T17:35:48.3866667+00:00 Hi @ Hamish HFL
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 27%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Fred Hanson 0 Reputation points2025-06-20T21:39:58.67+00:00 I am running into the exact same issue, and like the OP, the credentials work perfectly fine in other cases, so this seems like an issue caused by the involvement of ODBC.
Port 1433 is open.
DSN contains Authentication=ActiveDirectoryInteractive
Update your ODBC Driver to the latest version (18.7 or newer) — older versions may not fully support all AAD features.
I cannot find 18.7 anywhere, just 18.5.1.1, which I have installed.
MSAL is installed and working fine (again, connecting works fine outside of ODBC).
How do I even begin to diagnose this?
Sign in to comment
Sign in to answer