May 24, 2002 at 3:09 am
The situation.
A simple DTS job to copy records from a Ms-Access table to a MS-SQL Table.
The DTS runs with a job on an SQL2K server with a non-administrator account.
Non-administrator account use proxy account SQLJOBS to execute the DTSRUN command.
Problem:
- When I make SQLJOBS part of the local administrator group on the SQL*Server the jobs executes OK.
- When I make SQLJOB a normal user or power user on this server the job fails
This is the error:
Executed as user: Belgacom\SQLJobs.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Unspecified error
Error source: Microsoft JET Database Engine
Help file: Help context: 5000000 Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Unspecified error
Error source: Microsoft JET Database Engine
Help file: Help context: 5000000
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Can someone please help me?
P.S.: I don't want to make SQLJOBS part of the local admingroup. There must be another solution.
May 26, 2002 at 9:38 am
Does this normal user has permissions to read the access db
Steven
May 26, 2002 at 6:14 pm
This stood out:
quote:
Error source: Microsoft JET Database Engine
Does SQLJOBS have permissions to the directory where the Access database resides? Do you have the ability to run the DTS package (from inside package designer) as if at the console under the SQLJOBS account? If so, that'll give you a lot more detail than a SQL job report.
K. Brian Kelley
http://qa.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply