sp_xp_cmdshell_proxy_account gives a error, need help....

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » sp_xp_cmdshell_proxy_account gives a error,...

sp_xp_cmdshell_proxy_account gives a error, need help....

Rate Topic

Display Mode

Topic Options

Author

Message

Paresh Prajapati

Posted Thursday, July 24, 2008 3:01 AM

Old Hand

Group: General Forum Members
Last Login: Friday, August 31, 2012 6:08 AM
Points: 322, Visits: 459

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/
LinkedIn | Tweet Me | FaceBook | Brijj

Post #539937

Carl Uman

Posted Monday, February 28, 2011 1:01 PM

SSC-Enthusiastic

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
ORDER BY name

Good luck

Post #1070780

sudhanva

Posted Thursday, December 22, 2011 3:26 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, October 05, 2012 3:23 AM
Points: 79, Visits: 232

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 »

Permissions