Forum Discussion
Interactive authentication to Azure SQL Database
I am using Azure SQL Database and the authentication is based on azure active directory two factor authentication. As a foreground, I would like to have an MS Access database to link to SQL database ...
I don't want to save the password, I need the interactive authentication but only onetime when I open the Access database.
Mehr_sa123 It is my understanding that Access caches credentials so they remain valid during a session. You are working with Active Directory Interactive authentication which apparently acts differently. Consult the AD documentation.