Jobs will not run -- sql server dts

Tod Thames
12/5/2003 5:12:09 AM

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.

Allan Mitchell
12/8/2003 8:57:05 PM

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

[quoted text, click to view]

sql server dts : Jobs will not run