Skip to content

Support Active Directory Interactive for MSSQL databases in Azure #206

@RubenOlsen

Description

@RubenOlsen

Describe the bug
When using Authentication=ActiveDirectoryInteractive in the JDBC connection string one get an invalid authmethod.

To Reproduce
Run any MSSQL connection string with Authentication=ActiveDirectoryInteractive

Expected behavior
Expected behaviour is that browser pops up and the MFA will happen.

Additional context
I did an "in-place" upgrade of MSSQL JDBC driver to latest version from https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16#connect-using-activedirectoryinteractive-authentication-mode
It then complained about missing MSAL library - so I did a quick add of https://mvnrepository.com/artifact/com.microsoft.azure/msal4j/1.19.1

The browser now pop up (as expected) but it the process will loop and never authenticate correctly.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions