MS SQL Server DTS - Priviledges problem with "execute master..xp

Author

Priviledges problem with "execute master..xp_logevent&q

Nile

2005-09-27, 8:24 pm

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

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-Privile...pict258876.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=892553

Sue Hoegemeier

2005-09-28, 3:24 am

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@dbFor
umz.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

Sponsored Links