Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

sp_xp_cmdshell_proxy_account gives a error, need help.... Expand / Collapse
Posted Thursday, July 24, 2008 3:01 AM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 7:41 AM
Points: 323, Visits: 464
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';
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
LinkedIn | Tweet Me | FaceBook | Brijj
Post #539937
Posted Monday, February 28, 2011 1:01 PM


Group: General Forum Members
Last Login: Friday, February 15, 2013 1:54 PM
Points: 113, Visits: 109
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 *
from sys.credentials

This will show the config options for the server (the last entry for me was the xp_cmdshell)
SELECT * FROM sys.configurations

Good luck

Post #1070780
Posted Thursday, December 22, 2011 3:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 16, 2015 3:18 AM
Points: 79, Visits: 236

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.
Post #1225675
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse