Post reply

xp_cmdshell

  • September 30, 2005 at 12:48 pm

    #165505

    When you run xp_cmdshell, what account does the command access the network with? I am getting an access denied and all acounts defined on this server have access to the share.

  • September 30, 2005 at 2:31 pm

    #594411

    your sql server service account.

     

     

    mom

  • October 1, 2005 at 1:37 am

    #594436

    Try the thread below for links to configure SQL Server Agent with the correct permissions to run xp_cmdshell.  Hope this helps.

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=223910#bm224009

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • October 1, 2005 at 5:32 pm

    #594457

    The Agent acoount is only used if it is a job that runs xp_cmdshell. If you run it from QA, it is the SQL Server service account. So, it depends how xp_cmdshell is invoked.

    The third account applies to non sysadmins - then it's the agent proxy account instead.

    Perhaps it's better to establish first how the command is invoked, and by whom?

    /Kenneth

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

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