August 21, 2002 at 9:38 am
I'm trying to create a job to import several Foxpro db files on a weekly basis. The files are located on a network share and I've created at DTS package to handle the import which runs successfully, however when I schedule the package it refuses to run. This seems to have something to do with the Agent not being able to access a network share (I've had the same problem trying to open a network drive from activex script within a job step). I've been all over msdn for the past couple of days looking for an answer but there doesn't seem to be any documentation on this, except that it may not be a supported configuration.
Currently running SQL 7 desktop install on my local box with SP4 and W2K.
Thanks,
Phil
August 21, 2002 at 9:42 am
Does the user account your SQL Agent is running under have permission to access the share?
Michael Weiss
Michael Weiss
August 21, 2002 at 9:44 am
it should, the share is currently mapped as well but it won't open it using the virtual drive path either. (eg. tried accessing in using F:\...)
August 21, 2002 at 9:48 am
Does the Agent service use the startup account to validate against network resources, and if so can you modify what it's using to without changing the service startup account
August 22, 2002 at 9:12 am
It is hard to say what is going on without all the information. I agree with Michael. The first guess would be the servers should probably be in the domain in order to connect. That being said with FoxPro I have had some serious issues connecting when the domain account did not have access to the FoxPro server that held the databases.
To clarify, make sure you have an windows account that has access to the foxpro server and that can run the SQL server. Make sure this SQL Service account is used to start the agent.
Also, I have had problems running jobs when the job was owned by a user and not by sa.
I am using SQL 2000 so some of this may not be as relevant as you would like.
Bruce Szabo, MCSE+I, MCDBA, MCSD
Bruce Szabo, MCSE+I, MCDBA, MCSD
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply