I'm connecting to an SQL database through an ODBC driver (https://learn.microsoft.com/en-us/sql/odbc/microsoft/microsoft-odbc-desktop-database-drivers?view=sq...).
The odbc driver is authenticated via Azure AD and an Azure AD enterprise application.
The trouble we're having is that we can connect fine via browser login to AD (including MFA), but when using Azure AD authentication option in ODBC, the driver is typically only allowed access a short period and then the credentials (login/password) are denied.
Looking at the logs it seems to be because of required Multifactor Auth. which doesn't seem to work with the AzureAD auth option in ODBC.
Any thoughts, feedback or experiences with solutions to this issue?