469,964 Members | 1,455 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

Remote Exec of DTS MS Access Data Pump Task Returns Dreaded 80004005

Trying to exec DTS task involving load of MS Access table to SQL Server 2000 table using Data Pump task via remote exec of xp_cmdshell command of dtsrun. That is, on client, connect to database server and exec user stored procedure containing command EXEC xp_cmdshell @cmd where @cmd has been set to 'dtsrun /S /E /N DTS Package Name. Fails with:
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Unspecified error
Error source: Microsoft JET Database Engine
Help file:
Help context: 5000000

Remote execution of DTS Task not involving MS Access connection seems to work fine.

Client is NOT in sysadmin group so set up xp_sqlagent_proxy_account (account for user that xp_cmdshell "runs as") with Windows user having necessary Windows and SQL Server privileges to execute dtsrun and perform all work in DTS package run by dtsrun. Gave client priviliges, of course, to run extended stored procedure xp_cmdshell.

When logged directly on SQL Server, account setup as xp_sqlagent_proxy_account can successfully execute DTS package from Enterprise Manager or from command line using dtsrun. Again, however, same account cannot execute the Package when remotely invoked using xp_cmdshell.

Server is Windows 2003 with SQL Server at SP 4. Client is XP at SP 2. MS Access Jet engines appear to be fully up to date on client and server.

This seems like a permissions related problem, but I can't see the difference between running the DTS Package directly logged on as the xp_sqlagent_proxy_account and executing remotely. And why does it only occur for MS Access related DTS tasks?
Aug 7 '07 #1
0 1552

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Etienne Charland | last post: by
reply views Thread by Kolar | last post: by
3 posts views Thread by noelle.bond | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.