xp_logininfo problems

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  September 25, 2003 at 10:48 am

  #58858

  Am unable to get xp_logininfo to work correctly with a domain account...

  xp_logininfo 'DOMAIN\name'

  Server: Msg 8198, Level 16, State 24, Procedure xp_logininfo, Line 58

  Could not obtain information about Windows NT group/user 'DOMAIN\account'.

  Am able to run xp_logininfo and results are returned for non domain accounts. Has anyone experienced this problem or have any ideas exactly how the xp_logininfo works? I am running the command under the domain account which has sysadmin privileges...and xp_logininfo can not find itself.

  Thanks

  
  "Keep Your Stick On the Ice" ..Red Green

• brendt hess

  Hall of Fame

  Points: 3256

  More actions

  September 25, 2003 at 5:51 pm

  #475900

  This looks like an error documented by MS in mixed NT/2000 domains. See:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/6/43.asp&NoWebContent=1

  Also look at this:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/Articles/q233/1/61.asp&NoWebContent=1

• lila

  SSChasing Mays

  Points: 609

  More actions

  September 26, 2003 at 7:59 am

  #476005

  I had exactly the same problem and got rid of it when I changed my sqlserver and sqlagent startup accounts to domain accounts in stead of local admin accounts. But this is probably what you mean by 'running command under domain account'.

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  September 26, 2003 at 8:22 am

  #476020

  lila,

  I did the same thing about an hour after I posted my message and it fixed the problem. I am curious as to the security with the xp_logininfo proc.

  Thanks for the input everyone 🙂

  
  "Keep Your Stick On the Ice" ..Red Green