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

Pankaj Mendi 0

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;"

PRADEEPCHEEKATLA-MSFT 80,486 Reputation points Microsoft Employee

2024-05-20T05:10:21.33+00:00

@Pankaj Mendi - Just checking in to see if the below answer provided by @Alberto Morillo helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Alberto Morillo 33,086 Reputation points MVP

2024-05-15T03:48:04.8466667+00:00

Have you configured the Azure SQL firewall to allow access from Azure resources?

This video may help you connect from Azure Databricks to Azure SQL.

This is the documentation to connect using interactive mode and JDBC.
Please sign in to rate this answer.
Pankaj Mendi 0 Reputation points

2024-05-15T05:52:12.2733333+00:00

Thanks Alberto for your reply.

I did check the Allow azure services box but still the same result.

I also tried all kinds of browsers and also checked if default browser setting is good.

Any help would be appreciated. Thanks

Alberto Morillo 33,086 Reputation points MVP

2024-05-15T13:53:58.31+00:00

The JDBC URL you've provided is using the ActiveDirectoryInteractive authentication method, which requires an interactive sign-in process typically involving a system browser. This can be problematic in non-interactive environments like an Azure Databricks notebook, where the system browser may not be accessible.

Is it possible for you to switch to a non-interactive authentication method. Here's an example of how you can modify your JDBC URL to use the ActiveDirectoryPassword authentication method, which allows you to specify the username and password directly:

url = f"jdbc:sqlserver://{database_host}:{database_port};database={database_name};user={user}@{domain};password={password};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword;"
Sign in to comment

Share via

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

1 answer