I have a new SQL 2008 R2 Standard installed on Win 2008 R2 in mixed authentication mode. I can add my domain account as a Login with sysadmin permissions and connect via SSMS both locally when ran with admin and remotely from an XP workstation.
However, if I attempt to add a domain or local group, of which I am a member, to the login, grant that login/group sysadmin privledges, I am unable to login after removing my dedicated account. I have read a number of posts that refer to elevating
SSMS, etc but that is not the case with my issue as I am doing that and also attempting login from XP.
My exact error messages are:
Login failed for user 'xxxx\yyyyy'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 172.16.14.167]
Error: 18456, Severity: 14, State: 11.
Seems silly to add each administrator directly and not be able to use an AD Group.
View Complete Post