Sladescross's Blog

Blogging about Sharepoint related stuff

xp_cmdshell April 23, 2010

Filed under: Enable,EXECUTE AS,Impersonation,SQl Impersonation,xp_cmdshell — sladescross @ 8:35 pm

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45799

http://support.microsoft.com/kb/890775

Giving permissions outside the sysadmins role.

If you connect as a low-privilege login, then it will use the xp_cmdshell_proxy_account instead. So try doing EXECUTE AS LOGIN=’lowprivaccount’ first, to see if that helps.

http://www.mssqltips.com/tip.asp?tip=1020

Enable using sp_configure.

http://msdn.microsoft.com/en-us/library/ms175046.aspx

xp-cmdshell proxy account.

http://blogs.msdn.com/b/psssql/archive/2009/04/07/troubleshooting-sp-xp-cmdshell-proxy-account-errors.aspx

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′.

About these ads
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers