SQL server Login failed for user 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.
To fix it you need a State of error message - explanation why it failed. It could be found in error message or SQL Error log if failed logins added
Login failed for user - Error 18456 - Severity 14, State 38