My MS Access Application uses SQL Database as backend. The permission to SQL database is granted with Windows Authentication mode to a specific user group. Most of users in the group can get access to SQL database but there are some users reported to fail for login in the database.
The error message:
Connection failed SQLstate: '28000' SQL Server Error: 18456 Login failed for user Domain\UserID
I spent sometime searching for the solution but I could not find one with the same problem. Could anyone give me an advice on this? Many thanks.