Re: scheduling DTS fails with sa rights
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/07/04
- Next message: Sue Hoegemeier: "Re: DTS to run other DTS's"
- Previous message: D.J.: "Re: Using DTS for INSERT and UPDATE"
- In reply to: ralle: "scheduling DTS fails with sa rights"
- Next in thread: ralle: "Re: scheduling DTS fails with sa rights"
- Reply: ralle: "Re: scheduling DTS fails with sa rights"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 07 Apr 2004 05:49:24 -0600
Are you copying the data to a text file on another server?
In that case, you can't have SQL Agent running under local
system as that account does not have network access - you
would need to use a domain account.
You can find troubleshooting steps for problems when a
package doesn't run when scheduled in the following:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074
-Sue
On 7 Apr 2004 04:31:28 -0700, kralemann.r@bex.battenfeld.com
(ralle) wrote:
>Hallo to all,
>I hope the SQL and DTS experts can help me.
>I have problems with sheduling a small script copy data from Sql2000
>to a flat txt-file.
>When executing it in SEM on a different PC it works fine
>when sheduling it on the sql server it fails with error 208.
>I read a lot about this in the news group and thought the
>SQLSERVERAGENT has missing rights.
>I granted SA Permission to the services MSSQLSERVER and SQLSERVERAGENT
>( with local system account = has admin rights )
>I logged in on the server with also SA rights.
>I got everytime the same error.
>What should I do to allow SQLSERVERAGENT to execute the job.
>Many thanks in advance
>
>Ralf
- Next message: Sue Hoegemeier: "Re: DTS to run other DTS's"
- Previous message: D.J.: "Re: Using DTS for INSERT and UPDATE"
- In reply to: ralle: "scheduling DTS fails with sa rights"
- Next in thread: ralle: "Re: scheduling DTS fails with sa rights"
- Reply: ralle: "Re: scheduling DTS fails with sa rights"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
