1

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.

Hongnam
  • 21
  • 2
  • This question is far from reproducible or programming related. You can try [dba.se], but I doubt they'd be able to help you as well. For all we know, there's an active DENY LOGIN on the server for these users for some reason, which takes precedence over any allows – Erik A Nov 26 '20 at 09:52
  • first check if the users are in the group with xp_logininfo ...https://stackoverflow.com/questions/18751581/check-users-in-a-security-group-in-sql-server – lptr Nov 26 '20 at 09:53
  • Also check the SQL Server error log for related messages. – Dan Guzman Nov 26 '20 at 11:48

2 Answers2

0

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

SergeyA
  • 474
  • 3
  • 6
-1

If the users are indeed in the group, can you try to delete and readd the group to SQL Server login.

ant1008
  • 71
  • 2