Re: DATA Export

Hi,

When you run DTS package manually it runs in your security context. As you
are probably sysadmin it runs just perfectly.
But when you run it in a schedule it runs in a security context of a user
you have set it up for running...

Check the security settings in scheduling program.

--
Danijel Novak
MCP+I, MCSA, MCSE, MCDBA, MCT


"Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7858BC77-4FF4-45A4-BFBA-D61CE0592DC4@xxxxxxxxxxxxxxxx
> Good morning,
> I have a 2003 AD domain with a SQL2000 dedicated machine (server).
> I try to export on a windows 2000 server (excel or txt files) from my sql
> db.
> As I am runing my DTS myself, everything is ok... If I use the SQL planer,
> it does not work giving me an error 80004005 with acces denied. I believe
> it
> is a security problem but I do not know where as manualy dts works fine...
> Thanking you in advance.
> Regards
>


.

Relevant Pages

  • Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
    ... > And in what DB role on SQL Server is domain\user1? ... > www.SQLDTS.com - The site for all your DTS needs. ... >> Successful DTS package fails when scheduled as a SQL Agent job. ... >> between Agent and DTS security context as far as Access is concerned? ...
    (microsoft.public.sqlserver.dts)
  • Re: Security Issues using DTS package to refresh remote/DMZ website
    ... DTS runs and what you have exposed to that security context. ... analyze what the pipe you have opened potentially exposes to the outside ... customer info is sensitive) from a SQL Server on our internal network ...
    (microsoft.public.sqlserver.security)
  • Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >> www.SQLDTS.com - The site for all your DTS needs. ... >>> between Agent and DTS security context as far as Access is concerned? ...
    (microsoft.public.sqlserver.dts)
  • DTS Run
    ... I have a little problem with the security context of DTS. ... I have 2 DTS, the first DTS is started through an ASP page, No ... use the user context. ...
    (microsoft.public.sqlserver.dts)