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

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.

Enable using sp_configure.

xp-cmdshell proxy account.

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: Logo

You are commenting using your 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


Get every new post delivered to your Inbox.

Join 63 other followers