RE: Msg 15404: Could not obtain information about user
- From: Local Government System Inc <lgsystem@xxxxxxxxxxxxxxxx>
- Date: Sun, 18 May 2008 16:51:00 -0700
Hi Charles,
To answer your questions:
1. BuildUser is a "singleton" user account just as the previously working
BuildAdmin user is.
2. The trigger is a DML on-update auditing trigger to put the current time
into a column on the row being updated.
3. I have emailed the errorlog.
Also note, that I have been able to replicate the behaviour outside of the
daemon process. By RDPing to the servers as BuildUser, opening SSMS and
executing the same .sql file the daemon uses. Also, in SSMS as BuildUser, I
can replicate the same error message simply with this one line:
EXECUTE AS LOGIN = 'MYDOMAIN\BuildUser'
Thanks for your help,
--
Jason
.
- Follow-Ups:
- RE: Msg 15404: Could not obtain information about user
- From: "Charles Wang [MSFT]"
- RE: Msg 15404: Could not obtain information about user
- References:
- Msg 15404: Could not obtain information about user
- From: Local Government System Inc
- RE: Msg 15404: Could not obtain information about user
- From: "Charles Wang [MSFT]"
- Msg 15404: Could not obtain information about user
- Prev by Date: Re: SSL SQL 2005
- Next by Date: Capicom dll usage in SQL Server 200 gives EXCEPTION_ACCESS_VIOLATI
- Previous by thread: RE: Msg 15404: Could not obtain information about user
- Next by thread: RE: Msg 15404: Could not obtain information about user
- Index(es):