Post reply

RE: xp_cmdshell and rcmd

  • April 26, 2004 at 2:21 pm

    #108225

    Hi,

    I need to run a batch file on a remote server--testserver, so  I first assigned a domain account with local admin rights to sqlservice on both boxes and then used xp_cmdshell and rcmd to run that command like this:

    exec master..xp_cmdshell 'rcmd \\testserver  c:\test.bat'

     

    However, I always get this error : Error:8 - Internal error = 109

    Can someone tell me what's wrong?

    Thanks in advance.

     

     

  • April 26, 2004 at 3:11 pm

    #504267

    try

    exec remoteserver.master.dbo.xp_cmdshell 'test.bat'.

    you shoud add it as a linked server.

  • April 29, 2004 at 7:54 am

    #504674

    It worked. However, my problem is that the remote server doesn't have SQL installed. Is there anything else I can try?

     

    Thanks again for your time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply