all groups > sql server dts > july 2003 >
You're in the

sql server dts

group:

error -2147467259 (80004005) when schedule a DTS


error -2147467259 (80004005) when schedule a DTS masfer
7/28/2003 8:25:41 AM
sql server dts:
I get this error when i try to schedule a DTS with a proxi
account that is member of the local "power users" group:
----------------------------------------------------------
DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSCreateProcessTask_1
DTSRun OnFinish: DTSStep_DTSCreateProcessTask_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.
----------------------------------------------------------

If i put the user into the Administrators group, the job
goes fine.
Can anyone help me???
Thanks in advance.

Massimo Ferraresi
m.ferraresi@cribisnetgroup.com



Re: error -2147467259 (80004005) when schedule a DTS Allan Mitchell
7/28/2003 7:00:58 PM
This article should help you along

http://support.microsoft.com/?kbid=269074


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
Re: error -2147467259 (80004005) when schedule a DTS Darren Green
7/28/2003 8:08:40 PM
In article <003f01c3551c$81810f30$a301280a@phx.gbl>, masfer
<m.ferraresi@cribisnetgroup.com> writes
[quoted text, click to view]

Check that the user has permissions to write in that folder where the
mdb sits.

Jet likes to write a new file for locking, the ldb file, so read only
access will not normally suffice.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Re: error -2147467259 (80004005) when schedule a DTS masfer
7/29/2003 2:15:53 AM
I've checked the permission, but the user have FullControl
over the entire folder where the databases resides.
I have restarted the SqlServerAgent, but the error is the
same.
What do you mean for ldb files?
Thank you Darren for the answer.
Massimo Ferraresi



[quoted text, click to view]
Re: error -2147467259 (80004005) when schedule a DTS MasFer
7/29/2003 2:25:00 AM
Thank you Allan, but is the first thing that i've done
when I've implemented the DTS as a scheduleted job one
month ago.
Any other idea??
Many thanks.
Massimo Ferraresi



[quoted text, click to view]
Re: error -2147467259 (80004005) when schedule a DTS Allan Mitchell
7/29/2003 2:37:58 PM
OK

To verify this I would log into the server as the service account and fire up the package. This way you will get exactly what the Agent gets.
Try connecting to the servers that are listed in the DataPump tasks and the MS Jet datasources from the server as well. Basically mimic what the Agent account needs to do.


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
Re: error -2147467259 (80004005) when schedule a DTS Darren Green
7/30/2003 10:37:54 PM
In article <074701c355b2$02dc5680$a601280a@phx.gbl>, masfer
<m.ferraresi@cribisnetgroup.com> writes
[quoted text, click to view]
Access/Jet uses the mdb file (Fred.mdb), but when you open the DB it
also writes a Fred.ldb file to conrol locking. If you do not have write
permissions in the folder that holds the mdb the ldb cannot be created
so this can cause an error. Very cmmon on web sites that use Access as
often the ASP or ISUER_MACHINE account has no write access.

As a non-Adminstrator do you still have write access to the folder that
holds the mdb?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

AddThis Social Bookmark Button