November 15, 2007 at 4:40 am
Hi,
Could you please help me out this issue
I am facing an issue with xp_cmdshell
folowing are error message,how do i enable xp_cmdshell
"The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information. "
November 15, 2007 at 4:45 am
What is the account by which you have logged in?
Most likely you account is not a member of sysadmin role, then the SQL Server 2005 will use the proxy account to run the OS command which command called by xp_cmdshell. You omer must to create a credential first and mapping a window account using this command:
EXEC sp_xp_cmdshell_proxy_account ‘proxy account’ ,’password’
November 15, 2007 at 4:52 am
And to enable xp_cmdshell (if you haven't already), go to SQL Server Surface Area Configuration -> Features. This is where you can enable it. It'll be listed under the Database Engine as xp_cmdshell. There's a check box that you need to click on and that's all you need to get started.
Just remember that xp_cmdshell is disabled by default because of security issues. And just because you enable it doesn't mean you've got the proxy account stuff working.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply