xp_cmdshell fails

• Ian Goethert

  Say Hey Kid

  Points: 691

  More actions

  January 17, 2006 at 2:02 pm

  #188916

  I have an automated program that connects to a number of SQL 7 servers and runs xp_cmdshell.  However, there is one server that it always fails on.  I’ve looked at the configuration on the server and it appears to match the others.  Also note, if you run xp_cmdshell from the query analyzer using the same user account on the offending machine, it runs fine. 

   

  In my app, the connection reports:

  [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

  Timeout expired

   

  I’ve tried increasing the command timeout, and changing the data provider (oledb) but that didn’t make a difference.

   

  Anyone have any ideas?  Thanks in advance.

   

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  January 18, 2006 at 4:02 am

  #615413

  this sounds a little like the SQL service account may not have the relevant permissions for command executed by xp_cmdshell

  although it's just a wild stab in the dark

  MVDBA

• Ian Goethert

  Say Hey Kid

  Points: 691

  More actions

  January 18, 2006 at 4:22 am

  #615421

  Thanks Mike. 

  But it works using the same user and pass through query analyzer.  That's why I suspect it has to do with the connection.

  Ian

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  January 18, 2006 at 4:48 am

  #615432

  if it's the connection then that problemw ould apply to all commands issued, not just xp_cmdshell

  have you tried a simple xp_cmdshell 'Dir c:\' command to check other xp_cmdshell actions

  or try another command (sp_who2) from the connection that is causing problems

  MVDBA