Enabling user authentication to connect Access front end to Azure SQL Database
George Dimitrov
0
Reputation points
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive authentication.
However, only the Entra Admin is able to authenticate, and not any other users in the tenant. How can I enable user authentication for other users in the organization to connect to the database? I have read several articles about this, but I must be missing something.
Thanks in advance.