Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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';
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
Posted Monday, February 28, 2011 1:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
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, October 9, 2014 11:31 PM
Points: 79, Visits: 234

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