xp_logininfo et al

• Ira Dobrow

  Newbie

  Points: 5

  More actions

  January 18, 2007 at 1:17 pm

  #171918

  Hello all. I have three SQL servers - two are 2005 and one is 2000.

  When I do: EXEC xp_logininfo 'AIB\aipd','all'

  the 2000 server responds fine, but the 2005 servers respond with:

  Could not obtain information about Windows NT group/user 'AIB\aipd', error code 0x5.

  Deep down I think this is a network issue. The SQL 2000 instance is running on a Windows 2000 machine (I think), but the SQL 2005 instances are on Windows 2003 boxes.

  Does anyone know how to resolve this?

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 5:13 pm

  #684162

  It is woking fine on 2000 and 2005 sql server.

  Make sure login exists...try the following...

  declare @login sysname

  select @login = 'AIB\aipd'

  select @login

  if exists (select * from syslogins where name = @login)

  EXEC xp_logininfo @login,'all'

   

  MohammedU
  Microsoft SQL Server MVP

• Ira Dobrow

  Newbie

  Points: 5

  More actions

  January 19, 2007 at 9:25 am

  #684359

  Yes, the login exists.

  It is some kind of network/firewall/protocol something, probably caused by the emphasis on security in Windows Server 2003.

  I am looking for a clue to figure out what is closed on Windows 2003 that is not closed on Windows 2000.

  Thanks.

• Ira Dobrow

  Newbie

  Points: 5

  More actions

  January 22, 2007 at 8:38 am

  #684717

  We have sort of resolved the issue.

  We had been using a local account to run SQL Server.  When we switched to a domain account, the problem vanished!

  This proves that it is a domain/trust issue which we are exploring further, since we would prefer to run SQL Server with a local account.

  This URL is potentially helpful: http://support.microsoft.com/kb/834124

  I am considering this closed.