Problem with xp_cmdshell

  • Thread starter Thread starter Tomer
  • Start date Start date
T

Tomer

Hi,
I'm running a DTS from a stored procedure, using xp_xmdshell and running
DtsRun.exe.
The Dts runs a process (application) that send a report to the printer
(spooler).
I have a windows 2000 advanced server with Sql server 2000 developer
edition.
On this configuration everything works!
When I install Msde 2000, the Dts process gets stuck. and nothing happens.
If I try to run an ordinary application, such as doskey.exe, there are no
problems.

I've tried installing this configuration on: windows xp pro, windows 2000
pro.
But got the same results.

When I install Sql server 2000 developer edition, it works.

Any thoughts?
 
Hi Tomer:

First off, I think this may be the wrong group - this is
dotnet.compactframework. Anyway , it sounds like it may well be a
permissionsing problem. xm_cmdshell needs to be run with Admin privileges
from the way you are describing it here, and wondering what acct you are
using. Also, is this running across the network? IN SP3 network
connectivity is off by default so this may well be your problme.

Let me know if not.

Bill

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
 
Hi,
I'm sorry that I've posted the message here, its just because I'm running
the stored procedure from a ppc, not that it matters to the problem, I'm
just used to post messages here.

I've tried running the sql server with the system account, and also the
administrator account, but this didn't help.

How can I specify privileges for the xp_cmdshell?

Thanks.
 
Back
Top