CMDEXEC

  • Hi Everyone,

    ..Firstly, I have to state that I am new to this..

    I'm working on sql 2008 r2, trying to set up a proxy account.

    This is what I've done thus far :

    - set up a credential using a windows domain account

    - set up a proxy linking that credential and adding the necessary principals

    - I've linked job steps to this new proxy

    What else am I missing?

  • helpmewithsql 73993 (1/16/2012)


    Hi Everyone,

    ..Firstly, I have to state that I am new to this..

    I'm working on sql 2008 r2, trying to set up a proxy account.

    This is what I've done thus far :

    - set up a credential using a windows domain account

    - set up a proxy linking that credential and adding the necessary principals

    - I've linked job steps to this new proxy

    What else am I missing?

    Any error messages?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Sorry - it says:

    Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\SQL_Proxy_Username, system error: Logon failure: unknown user name or bad password.). The step failed.

  • helpmewithsql 73993 (1/16/2012)


    Sorry - it says:

    Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\SQL_Proxy_Username, system error: Logon failure: unknown user name or bad password.). The step failed.

    Apologies for the delayed response.

    The post that padhis cited has most of the possible answers. For your particular problem, it simply sounds like the CmdShell proxy either wasn't setup correctly or the password for the proxy has been changed on the Windows side of the house.

    Go to the link that padhis cited... it covers a whole lot about this in a short period of time with some code examples, to boot.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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