Execute as Full Domain Name results in Could not obtain information about Windows NT

• Antonuel

  Old Hand

  Points: 348

  More actions

  March 24, 2015 at 3:30 am

  #315979

  Looking for some ideas on why this is happening.

  SQL Server 2008R2 SP1

  Full Domain Name: company.local

  Domain Name (pre-windows 2000): COMP

  We just found that that running queries as COMPANY.LOCAL\UserAccount results in "Could not obtain information about Windows NT group/user 'company.local\UserAccount', error code 0xffff0002."

  For instance:

  EXECUTE AS LOGIN='company.local\UserAccount'

  SELECT * FROM sys.objects

  REVERT

  Msg 15404, Level 16, State 11, Line 1

  Could not obtain information about Windows NT group/user 'company.local\UserAccount', error code 0xffff0002.

  But if I use the short domain name it runs fine.

  EXECUTE AS LOGIN='COMP\userAccount'

  SELECT * FROM sys.objects

  REVERT

  The issue was identified by a developer trying to run a SSIS package from a job on a SQL Agent that was using the service account configured as COMPANY.LOCAL\svcSQLAGTAccount

  We fixed the issue by changing the account to COMP\svcSQLAGTAccount and restarting the service. I still would like to know what the issue is?