Error: Access is denied while writing output using sqlcmd in xp_cmdshell

• ganu.mumbai

  SSChasing Mays

  Points: 620

  More actions

  October 22, 2010 at 12:48 am

  #142249

  Hi,

  How can we solve the issue of Error: Access is denied while writing output using sqlcmd in xp_cmdshell.

  Exact ERROR: Sqlcmd: Error: Error occurred while opening or operating on file D: (Reason: Access is denied).

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  October 22, 2010 at 3:57 am

  #1240798

  you need permission to run xp_cmdshell, if id not belongs to sysadmin then provide grant permission on that id and add that user in master as well

  ----------
  Ashish

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  October 22, 2010 at 8:11 am

  #1240941

  ranganathan.arumugham (10/22/2010)

  ---

  Hi,

  How can we solve the issue of Error: Access is denied while writing output using sqlcmd in xp_cmdshell.

  Exact ERROR: Sqlcmd: Error: Error occurred while opening or operating on file D: (Reason: Access is denied).

  Check if the SQL Server service account has permissions on the file D:\*****

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• guessme

  Old Hand

  Points: 350

  More actions

  February 9, 2012 at 8:03 am

  #1445094

  Actually i also getting same error, i added sqlservice acct to that folder,i dnt know what i have to do?any0ne please post your suggestion.

• chandanpandey1001

  SSC Enthusiast

  Points: 100

  More actions

  February 11, 2012 at 3:17 am

  #1445871

  Post your statement please.