SQL Login cannot connect to Database Recently I attended one interview and this was the question:

Many Users reported that they are not able to connect to server.Where as I can connect to server.

My Answer :

I will check out their permissions in security context if their access is revoked or lost (But they still have permissions).
May be their accounts are locked (No their accounts are not locked).

The Interviewer still expects more answer. What am I missing here? Can anyone help.

I thought of telling trigger but I am not sure .
I would check if the users get access via an Active Directory Security Group.