I have just migrated a db from one SQL Server to another.
Everything seems to work fine. All of my DTS's work
perfectly on the new system, however when I schedule the
JOBS to run at night, the fail. This is what it says when
I pull up the View Job History:

DTSRun: Loading... Error: -2147217843 (80040E4D); Provider
Error: 18456 (4818) Error string: Login failed for
user '\'. Error source: Microsoft OLE DB Provider for SQL
Server Help file: Help context: 0. Process Exit Code 1.
The step failed.

I can't remember how to give permission for the system to
run JOBS.

I am using a mixed authentication.

The SQL Server agent says to use the Windows NT
Authentication.


All help is appreciated.

The System account will not see anything off it's own location. Is the SQL
Server Agent a Domain User account ? If it isn't then make it one and then
read this

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tod Thames" <tod.thames (AT) nc (DOT) ngb.army.mil> wrote