How to change SQL Server 2000 Package job executor to access network drive

Last Post 20 Dec 2005 03:03 AM by mwesch. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bcglucky
New Member
New Member

--
19 Dec 2005 08:56 PM

I've made a Package named 'overlmt' which run properly by current lan user on the domain (domain/danny) manually.
Inside package step2 I call a mdb database on LAN (for example w:\xxx\xxx\xx.mdb).
When I add the package to Sql Agent-> Jobs to let it run automatically on scedule.
The job is Executed by "SYSTEM" role which only play in database , so can not access network database(xx.mdb) and drive.
How can I let the job run properly.
Can I change the Executor of the package job from "SYSTEM" role to a domain user of internal LAN on the Sql Agent, or other solutions?
Thanks for help.

jobs error script attached:

The execution of the following DTS Package succeeded:

Package Name: overlmt
Package Description: (null)
Package ID: {7AF5A3C4-7D11-4960-8ED1-A7995334B2CC}
Package Version: {21349A0D-E488-4D6A-9A53-D896B20E1610}
Package Execution Lineage: {5E01BBE6-690C-4B3E-B8C7-D92D9AAE02A9}
Executed On: SHAEDPD26
Executed By: SYSTEM
Execution Started: 12/19/2005 4:00:01 PM
Execution Completed: 12/19/2005 4:00:02 PM
Total Execution Time: 0.531 seconds

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft JET Database Engine
Step Error Description:The Microsoft Jet database engine cannot open the file '\\fileservername\folder\over.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003051
mwesch
New Member
New Member

--
20 Dec 2005 03:03 AM
Need to change SQL Agent service to run under domain account, and then give that domain account access to the MDB share/directory/file.
bcglucky
New Member
New Member

--
21 Dec 2005 06:03 PM
I wonder how to change SQL Agent service to run under domain account.
I'd like to get the detail step by step.
Thank you very much.
bcglucky
New Member
New Member

--
21 Dec 2005 06:05 PM
Sorry, I found it myself now.
By the way, thank you.
You are not authorized to post a reply.

Acceptable Use Policy