Error running xp_cmdshell

• vhanda

  SSCrazy

  Points: 2240

  More actions

  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

• jraha

  SSC Eights!

  Points: 817

  More actions

  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

• lindss01

  SSCrazy

  Points: 2264

  More actions

  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