Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInteractive

PankajMendi — Tue, 14 May 2024 11:59:05 GMT

Getting below error while accessing Azure sql using jdbc from Azure databricks notebook,

com.microsoft.sqlserver.jdbc.SQLServerException: Failed to authenticate the user p***** in Active Directory (Authentication=ActiveDirectoryInteractive). Unable to open default system browser

Here is the url of jdbc,

url = f"jdbc:sqlserver://{database_host}:{database_port};database={database_name};user={user};password={password};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryInteractive;"

Re: Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInterac

-werners- — Fri, 17 May 2024 07:24:13 GMT

it seems you are trying to do MFA authentication using jdbc.
The used driver might not support that. It could also be a OS issue (if you are not using Windows f.e.) or a browser issue (the browser will have to open a window/tab).
Can you try to authenticate using a service principal, or bypass the MFA?

topic Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInteractive in Data Engineering

Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInteractive

Re: Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInterac