Msg 15404: Could not obtain information about user

Hello,

We have two build servers running Windows Server 2003 R2 SP2 and default
instances of SQL Server 2005 SP2, I'll refer to them as ServerA and ServerB.

Both servers are members of our only domain (MyDomain) and each SQL service
runs as a domain account (ServerASqlUser and ServerBSqlUser) which is a
member of the default group Domain Users only.

Until recently a service on both servers, running as a Domain Admin user
BuildAdmin, would regularly execute database create and load scripts.
BuildAdmin is also a member of the sysadmin role on both servers. This works
fine.

This week the daemon running as BuildAdmin was changed to run as a new user,
BuildUser, which is a member of Domain Users only. BuildUser was also added
to the sysadmin role on both SQL servers. However this fails now on both
servers.

During the load script, a trigger created 'WITH EXECUTE AS OWNER', is
failing with the following message:
Msg 15404, Level 16, State 19, Procedure MyTable_MyUpdateTrigger, Line 0
Could not obtain information about Windows NT group/user
'MYDOMAIN\BuildUser', error code 0x5.

This is odd because the daemon is connected to SQL and running the create
and load script as MYDOMAIN\BuildUser and I have verified that
MYDOMAIN\BuildUser is the db_owner of the database. The servers have been
restarted. The two domain controllers have been restarted. I have added
BuildUser to each build servers' local Administrators group. Nothing helps.

Can you please advise what may be causing this or what else I can do to
further track and debug this issue to find a solution?

Regards,

--
Jason
.

Relevant Pages

  • Re: Remote disk space analysis
    ... Check the drive space on all of the servers listed in a text file and store the output like Server name, Drive Name, Disk Space and Free space information on a SQL Server table. ...
    (microsoft.public.scripting.vbscript)
  • Re: SQL Clustered Node restarting unexpectedly
    ... Found it to be a NMI that was caught by the system BIOS ... Mike Epprecht, Microsoft SQL Server MVP ... > Servers on 2 nodes connected to SAN Storage using Fibre ... > for network name resource SQL network name ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access denied as Users and Power Users
    ... check who's member of the Administrators group on one of the servers wher ... it may be that "Domain Users" is actually a member of the ... > The 3 Servers are configured identically.. ...
    (microsoft.public.win2000.general)
  • Re: using windows authentication...
    ... SQL Server DOES NOT TALK TO WEB ... Web clients request access and data from database servers, ... Server security. ...
    (microsoft.public.sqlserver.server)
  • Re: Hiding MS SQL databases in Enterprise Manager
    ... > When I create a database in the Microsoft SQL Server, ... > security issue, I would like to set it up so that users can only see ... > databases for which they've been assigned a role. ... your SQL servers, not at preventing a list of them. ...
    (Focus-Microsoft)