Pulling data from shared drives

I am trying to update and pull data from a table on an
Access database that is located on a shared Novell drive.
When I run the DTS package there is no problem. When I
run the DTS Package through a scheduled job, the job
fails. I keep the SQL Server logged in as "Administrator"
so it keeps the shared drive while the job is running.
Still the job fails. Does any one know why this happens?SQL cannot see the mapped drive since it is running under a service account.
Make sure you use UNC names and that the service account for SQL has
permissions to access the network location. If you run SQL under
localsystem it cannot access network resources such as remote file shares.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <mmather@.semprautilities.com> wrote in message
news:106701c3724a$a8d47c70$a601280a@.phx.gbl...
> I am trying to update and pull data from a table on an
> Access database that is located on a shared Novell drive.
> When I run the DTS package there is no problem. When I
> run the DTS Package through a scheduled job, the job
> fails. I keep the SQL Server logged in as "Administrator"
> so it keeps the shared drive while the job is running.
> Still the job fails. Does any one know why this happens?|||Mike,
When the job is being run, it uses the account under which sqlagent runs.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <mmather@.semprautilities.com> wrote in message
news:106701c3724a$a8d47c70$a601280a@.phx.gbl...
> I am trying to update and pull data from a table on an
> Access database that is located on a shared Novell drive.
> When I run the DTS package there is no problem. When I
> run the DTS Package through a scheduled job, the job
> fails. I keep the SQL Server logged in as "Administrator"
> so it keeps the shared drive while the job is running.
> Still the job fails. Does any one know why this happens?|||More details here..
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OKX3awkcDHA.356@.TK2MSFTNGP11.phx.gbl...
> Mike,
> When the job is being run, it uses the account under which sqlagent runs.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Mike" <mmather@.semprautilities.com> wrote in message
> news:106701c3724a$a8d47c70$a601280a@.phx.gbl...
> > I am trying to update and pull data from a table on an
> > Access database that is located on a shared Novell drive.
> > When I run the DTS package there is no problem. When I
> > run the DTS Package through a scheduled job, the job
> > fails. I keep the SQL Server logged in as "Administrator"
> > so it keeps the shared drive while the job is running.
> > Still the job fails. Does any one know why this happens?
>|||Thank you for your help
>--Original Message--
>SQL cannot see the mapped drive since it is running under
a service account.
>Make sure you use UNC names and that the service account
for SQL has
>permissions to access the network location. If you run
SQL under
>localsystem it cannot access network resources such as
remote file shares.
>--
>Geoff N. Hiten
>SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>
>
>"Mike" <mmather@.semprautilities.com> wrote in message
>news:106701c3724a$a8d47c70$a601280a@.phx.gbl...
>> I am trying to update and pull data from a table on an
>> Access database that is located on a shared Novell
drive.
>> When I run the DTS package there is no problem. When I
>> run the DTS Package through a scheduled job, the job
>> fails. I keep the SQL Server logged in
as "Administrator"
>> so it keeps the shared drive while the job is running.
>> Still the job fails. Does any one know why this
happens?
>
>.
>