ERROR CREATING PROXY ACCOUNT....

  • Hello again,

    I´m having the following error when i try to re enable one proxy account (1.-). I detect this problem after i've got one other problem with one SQL Server Login try to access one share (2.-). However when i execute xp_sqlagent_proxy_account to get the account that is used for the proxy the command returns the username that i'm using to the proxy account (3.-)

    Note: I'm getting this problem in SQL 2000

    Hope u can help me.

    Thanks and regards,

    JMSM 😉

    -----------------------------------------------------------------------------------------------------

    1.-

    EXEC master.dbo.xp_sqlagent_proxy_account N'SET',

    N'domain_name', -- agent_domain_name

    N'username', -- agent_username

    N'***********************' -- agent password

    The system cannot find the path specified.

    -----------------------------------------------------------------------------------------------------

    2.-

    exec xp_cmdshell 'dir \\ip_address\fileshare'

    Msg 50001, Level 1, State 50001

    xp_cmdshell failed to execute because LogonUserW returns error 1326. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_account.

    -----------------------------------------------------------------------------------------------------

    3.-

    EXEC master.dbo.xp_sqlagent_proxy_account N'GET'

    DOMAIN_NAMEUSERNAME

  • Hi Jorge,

    Did you ever get an answer from anywhere for this problem? If so, how did you solve it? Thanks.

    --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 2 posts - 1 through 1 (of 1 total)

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