Post reply

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

  • 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).

  • 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

  • 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

  • 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.

  • February 11, 2012 at 3:17 am

    #1445871

    Post your statement please.

Viewing 5 posts - 1 through 4 (of 4 total)

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