Priviledges problem with "execute master..xp_logevent&q

Here is what I experienced when trying to get the logging into SQL server’s Application Event log.

If I execute the DTS package from Enterprise Manager using a SQL Server authenticated account I am able to get the “execute master..xp_logevent” call to work.

If I create a SQL job from the DTS package and run that sql job using a Windows authenticated domain account as the owner of the job I am not able to get the ‘execute master..xp_logevent” call to work. Note that this login has dbo rights to the master database.

Help Please!
Thanks
Nile

If you run a DTS package from a job and the job is not owned
by a sysadmin, it executes under the security context of the
proxy account - not the owner of the job. So it would be the
proxy account that needs the appropriate permissions rather
than the job owner.

-Sue

On 27 Sep 2005 20:37:56 -0400, Nile
<UseLinkToEmail RemoveThis @dbForumz.com> wrote:

>Here is what I experienced when trying to get the logging into SQL
>server’s Application Event log.
>
>If I execute the DTS package from Enterprise Manager using a SQL
>Server authenticated account I am able to get the “execute
>master..xp_logevent” call to work.
>
>If I create a SQL job from the DTS package and run that sql job using
>a Windows authenticated domain account as the owner of the job I am
>not able to get the ‘execute master..xp_logevent” call to work. Note
>that this login has dbo rights to the master database.
>
>Help Please!
>Thanks
>Nile