I'm seeing login failures to our end users on our server
which has recently migrated to Windows/SQL 2012.
Severity: 14, State: 11. is what it shows in the logs.
In ring buffers below are the error codes. ErrorCode: 0×534 CallingAPIName: LookupAccountSidInternal APIName: LookupAccountSid
Which indicates that SQL Cant resolve the name against
But one of my another SQL instance is also hosted on
the same node of the cluster where in the user is having no issues connection.
I ran the below thing which was intresting to see on
2 different SQL instances that are hosted on the same cluster and same node. EXEC xp_logininfo 'Redmond\UserAlias','all' On Problematic instance: It did not give me results. On other sql instance: It gave me list of all the Security
groups the user is part of.
Oh i should mention this. UAC is enabled on this node