Post reply

Using XP_CMDSHELL

  • September 10, 2003 at 7:33 pm

    #81043

    Hi,

    I need to create an trigger that excutes an exe application when the data is inserted into the table. In the Query Analyzer I used the exec xp_cmdshell to execute the exe application, but i can not see the application visually, but the task manager shows me that process is running. I cann't even terminate this process as it says access denied.

    Is there any permission i need to set to run this command from Query Analyzer or any other alternate?

    Thanks so much for your help.

    Regs

    Murali

  • September 11, 2003 at 7:13 am

    #473707

    You have to have 'sa' right or create SQL Server Proxy account or grant execution permission on this xp to specific users.

  • September 11, 2003 at 8:00 am

    #473724

    Or someone with sysadmin server role.

    .

  • September 11, 2003 at 8:46 am

    #473740

    Hi,

    I've tried with sa id, also i've created new account by granting all the permissions, but still the same.

    any other reason?

  • September 11, 2003 at 8:57 am

    #473742

    How are you starting your SQL Server Service? Is it a Domain Account? Or a local system account?

    .

  • September 11, 2003 at 7:22 pm

    #473837

    I am running as local system account.

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

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