I have SQL 2008 x64 (mixed mode) installed on Windows 2008 x64. When trying to login to SQL using my Domain Admins account, I get the following error:
Login failed for user 'DOMAIN\username'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: X.X.X.X]
answer? "Run as administrator" the SQL Server Management Studio!!
Apparently UAC does not pass your user group membership properly to the SQL Server Management Studio.
No comments:
Post a Comment