Post reply

Account used executing xp_cmdshell dtexec

  • October 1, 2007 at 1:23 pm

    #177869

    Hi, this is my first post. I hope somebody could help me.

    This is the situation. I'm executing xp_cmdshell from a SP to call an Integration Services package at PC1. Then the SSIS package connects to PC2 to bring a table from MS Access, update on SQL server database on PC1 and bring it back to PC2. The problem here is that xp_cmdshell use de Local System account (according to "SQL Server (MSSQLSERVER)" service) and when the package tries to obtain data from PC2 the Jet OLEDB connection to the MS Access fails.

    I think that the question is...is there any possibility to run xp_cmdshell with other account than the Local System ? for example the domain account of the user executing the xp_cmdshell...

    NOTE: Change the account specified in the services is not an option.

    Thanks in advance

  • October 1, 2007 at 2:15 pm

    #737881

    See the following in BOL:

    sp_xp_cmdshell_proxy_account

  • October 2, 2007 at 6:41 am

    #738108

    Thanks for your reply, but in BOL that concept, like others, it´s very summarized. It tells me nothing about how to use it. Once I create the proxy account how could I use it to execute the xp_cmdshell with that account instead of using the Local System specified in Sql Server (MSSQLSERVER) service ?

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

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