How to use ActiveDirectoryInteractive (MFA) in spring boot application for authenticating SQL server

Savio Vegnesa 56

We are trying to connect azure sql server using ActiveDirectoryInteractive method from spring boot application

We have addes following in application.property

spring.datasource.url=jdbc:sqlserver://servername:portNo;database=databaseName;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
spring.datasource.hikari.data-source-properties.authentication=ActiveDirectoryInteractive

But we are getting error as
com.microsoft.aad.msal4j.MsalClientException: Unable to open default system browser

GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2022-09-10T00:07:46.25+00:00

HI, @Savio Vegnesa Thanks for posting your question in the Microsoft Q&A forum.
The exception looks from the client driver side. Which version of the Client driver are you using?
I tried to search some reference documents based on the error you have received, try if this might help you.
Check here on MSAL.NET, however, I am also checking with the internal team to provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2022-09-13T23:49:34.14+00:00

@Savio Vegnesa We haven't heard back from you In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Regards
Geetha

Share via

How to use ActiveDirectoryInteractive (MFA) in spring boot application for authenticating SQL server

Your answer