Hi
We are working on asp.net core application. We are not able to connect to Azure SQL database using service account with azure active directory password authentication.
Getting error that authentication keyword is not supported.
Is there any way to use service account with azure active directory password to access azure SQL database?
Or managed identity is only the way to access database in asp.net core mvc application?