Post reply

Error running xp_cmdshell

  • March 4, 2003 at 11:28 am

    #450254

    J,

    Try running the following through QA under the same account:

    exec master..xp_cmdshell 'SET'

    and this should return the list of environment variables available to xp_cmdshell when it executes under that account.

    Vik

  • March 4, 2003 at 12:07 pm

    #450256

    Great tip... but I'm a little confused. Did that just show me what was previously already set, or did that set the environment variables for the user accessing dos from sql server.

    http://www.computerhope.com/sethlp.htm

    Previously I had to type the following to execute my importExcel.pl file:

    e:\perl\bin\perl.exe e:\perl\excel\importExcel.pl

    After running the set command, I was able to execute the following command:

    perl e:\perl\excel\importExcel.pl

    Thanks so much,

    -Joel

  • March 7, 2003 at 8:46 am

    #450544

    I am running SQL Server 2000 SP 3. I am logged on as sa. I am point to either master or a user database. I run from my workstation in Query Analyzer master..xp_cmdshell 'dir c:\'.

    I get the following message.

    Msg 50001, Level 1, State 50001

    xpsql.cpp: Error 87 from GetProxyAccount on line 604

    Any thoughts on why?

    Edited by - lindss01 on 03/07/2003 08:48:34 AM

Viewing 3 posts - 16 through 17 (of 17 total)

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