Login failure to SQL instance in 2012


  • 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 AD.

    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

    Monday, July 08, 2013 5:09 PM


All replies