I have installed a named instance of SQL Server 2008 R2 Enterprise 64 bit on Windows Server 2008 R2 Enterprise 64 bit. The os is running as a VM ware virtual machine.
I have created an AD security group for database engine sys admins on that machine. I added my user to that group.So for example;
domainname\machinename_SQL_DBE_SysADmins is a user with SysAdmin server role permissions. User domainname\MichaelEFF is a member of this group.
When I log onto the machine as this user and run the management studio with run as administrator I cannot log into the database engine. The log shows the error:
Login failed for user: Reason:Token-based server access validation failed with an infrastructure error
I've read many posts where the MVP says that the UAC is not passing the group membership. Is this the case? If so then how will role based access ever be possible with windows authentication? How can this be resolved?
Thanks Siva, I saw the MSDN forum response, but this is not applicable due to the fact that I already have other users (logins) provisioned. The UAC is enabled on this W2k8 R2 Enterprise machine and there is no way to disable it as in the article you suggested.
Has anyone resolved this issue at all? I am about to open a premier support case on this.