SQL Server Performance

xp_logininfo

Discussion in 'General DBA Questions' started by xiebo2010cx, Apr 25, 2007.

  1. xiebo2010cx Member

    I was able to use 'xp_loginingo' to find out the members of BUILTINAdministrators'
    But
    I can not use xp_logininfo to find out the members in the specific windows group,

    I have both window level and Sql server level Admin right.

    Server: Msg 8198, Level 16, State 12, Procedure xp_logininfo, Line 38
    Could not obtain information about Windows NT group/user 'DomainUserGroup'.

    What may be the potential reason for this failure, lack of the active directory privilege?

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  2. satya Moderator

    KBAhttp://support.microsoft.com/kb/834124 explains the issue to rsolve.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page