SQL 2008. I have user in a db which has no login on the server. How is it possible?
- by Boppity Bop
I am talking about windows authentication.
I dont have access to the server adming rights but a dbadmin sent me screenshot where my user is not in the logins of the server. and also there is only one windows group called admin - databases which I am 100% sure my guy cannot be part of it.
BUT... his username is in users of my db...
How come user can appear in a db not having login on the server?
P.S. in the logs it prints: Login failed for user 'xxxx'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors