MS Access connection to SQL server 2 factor authentication

Question

How to enable two factor authentication in MS Access. I wanted to connect the SQL server with NT login ID and SQL server login ID. I need both level of authentication to connect the SQL server.  Please help me on this.

Answer 1

Thanks Tom for your response.

We have a dedicated service account(with Username and password) which needs to be authenticated using windows Authentication in MS Access external data connection(SQL server in this case). so any ideas how it can be done?

Answer 2

What exactly is your use case? I have a hard time thinking of the scenario where you would need two forms of identification to access the database. Do you not trust Active Directory?

See also: Use Azure Active Directory Authentication for authentication with SQL Database or SQL Data Warehouse https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication

Answer 3

No.  Well, not that I've ever seen.

Also note that i revised my original reply!

Answer 4

Thanks for the reply Daniel. Let me check in SQL forum as well.... Is there any option to enable for 2 factor authentication in MS Access

Answer 5

You should ask such questions in an SQL Server forum.

Set the authentication to SQL Server and Windows Authentication mode

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode