RE: Msg 15404: Could not obtain information about user

Hi Charles,

The SQL services are definitely configured to run as MYDOMAIN\ServerASqlUser
and MYDOMAIN\ServerBSqlUser. There are definitely no local users of the same
name on the servers.

These two users are members of MYDOMAIN\Domain Users, a security group that
seems to automatically exist on all new domains and all new users are
normally automatically a member of.

I have changed the trigger causing the error to be defined as:
CREATE TRIGGER [dbo].[MyTable_MyUpdateTrigger]
ON [dbo].[MyTable] WITH EXECUTE AS OWNER AFTER UPDATE AS
SELECT 1

And the error still ocurs.

I have compiled the minimum script necessary to reproduce the error on my
servers and emailed it to you.

Thanks for your persistence.

Regards,

--
Jason

.

Relevant Pages

  • Re: ChoralTalk/rec.music.makers.choral gateway deactivated
    ... half-decent Usenet news service for just one group? ... and I post/receive directly to/from Microsoft's news servers, but last time I checked on other news-servers, completion was spotty. ... We are using it as a way for members of our choir to discuss ...
    (rec.music.makers.choral)
  • Re: AD Integrated zone deleted, cant recreate secondary zones
    ... users are just logging in to the member servers as ... > local users and accessing what they need through mapped drives. ... make sure all zones for the domain are deleted ...
    (microsoft.public.win2000.dns)
  • Re: Renaming a domain
    ... member servers of the exchange.local domain or any other domain. ... We have 25 Windows XP Pro clients that are members of five different ... workgroup but are not members of the exchange.local domain. ...
    (microsoft.public.windows.server.migration)
  • Re: NDR but delivered?
    ... >I currently have 3 main sites with different local domain names and one ... >Keep getting these NDRs for local users and external users in same mail ... I am forwarding through smarthosts. ... In a normal configuration your three servers would mesh mail between ...
    (microsoft.public.exchange2000.admin)
  • Re: Group shows members SID instead of account name
    ... I have 2 Windows 2000 Servers SP4 as ... local user accounts. ... domain user to the group but their SID only displays. ... > members box instead of the account name. ...
    (microsoft.public.win2000.active_directory)