sp_xp_cmdshell_proxy_account gives a error, need help....

  • I have create a domain use testuser,

    and i have create a CREDENTIAL :

    create CREDENTIAL ##xp_cmdshell_proxy_account## with IDENTITY = 'domainname\testuser', SECRET = 'password';

    Then when i create a proxy_account :

    EXEC sp_xp_cmdshell_proxy_account 'domainname\testuser', 'password';

    GO

    i git following error:

    Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account, Line 1

    An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons: the provided account was invalid or the '##xp_cmdshell_proxy_account##' credential could not be created. Error code: '5'.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • I know this is an old post but I've been looking for answer to this so I'm putting what I've found here for the next person.

    Wish I could give a better answer but a couple of options.

    1) someone posted that logging in as admin

    2) CREATE CREDENTIAL ##xp_cmdshell_proxy_account## WITH IDENTITY = 'domain account',secret = 'password'

    Option two worked for me. As the time of this post I didn't mess with trying option 1 since the login I'm using has sysadmin role.

    This will remove the credential...

    EXEC sp_xp_cmdshell_proxy_account null

    This will show a list of credentials on server

    select *

    fromsys.credentials

    This will show the config options for the server (the last entry for me was the xp_cmdshell)

    SELECT * FROM sys.configurations

    ORDER BY name

    Good luck

  • Can we have more than one windows user configured as proxy? How?

    Actually, I have two Application servers using same database server. Both of them have two seperate users, which i need to configure in db server.

    Please help.

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

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