By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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