I have a single user who connects to SQL (SQL management tool)and gets access denied on a particular server.
Another user in the same groups as user 1 is fine.
User 1 can access if I put into the local admin on the server
User 2 can access just fine not in local admini
User 1 has multiple AD accounts, when he started as a contractor then moved to perm, etc.
I am tempted to kill all his accounts then start with a fresh one but before I did that I thought I would try to solve it.