Scheduled DTS package fails

Last Post 24 Jan 2007 09:02 AM by ConKi. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ConKi
New Member
New Member

--
24 Jan 2007 08:40 AM
Greeting All,

I set up a DTS package right on the server using the win authentication and it works fine, but it fails when I scheduled it (right on the server).

The win auth login has sys admin right.

Please help!!!!

Thanks,

ConKi
ConKi
New Member
New Member

--
24 Jan 2007 09:02 AM
That is it!!!!

Thank you russellb. The SQL Server Agent runs on different login.

Again, thank you,

ConKi


Acceptable Use Policy
---