Receiving Error 15404 (Error code 0x5) When Attempting `Execute As` Statement

• adam.fortuno

  Old Hand

  Points: 349

  More actions

  September 5, 2008 at 4:34 pm

  #96527

  I have a service account `foo` that my web site uses to interact with the (SQL Server 2005) database. The site is having an issue running a procedure that I can run just fine. I attempted to run the routine under the service account's context using the `EXECUTE AS USER` construct; however, SQL Server throws an exception when I attempt to run the statement. The exception reads as follows:

  [font="Courier New"]Msg 15404, Level 16, State 19, Line 1

  Could not obtain information about Windows NT group/user 'CORPORATE\foo', error code 0x5.[/font]

  Here is the statement I am executing:

  EXECUTE AS USER = 'CORPORATE\foo';

  I confirmed the login exists in the `sys.database_principals` view, and I can see expected results for the login when I use `sp_HelpUser` and `sp_HelpLogins`.

  I am stumped. Any ideas?

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  September 6, 2008 at 7:17 am

  #868140

  Hello,

  Did you spot this MS KB article already?

  http://support.microsoft.com/kb/834124/en-us

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group