July 24, 2008 at 3:01 am
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'.
February 28, 2011 at 1:01 pm
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
December 22, 2011 at 3:26 am
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