Reputation: 1612
My setup:
sp_xp_cmdshell_proxy_account 'box\proxy', 'pwd here'
xp_cmdshell 'dir \\myshare.file.core.windows.net\myshare'
, but getting The user name or password is incorrect.
xp_cmdshell 'whoami'
, getting back box\proxy
as expectedWhat I have tried so far:
tried making "proxy" account an administrator on the box, restarted sql service, no luck
tried adding "proxy" account as sql login, even giving sysadmin, again no luck
i've changed proxy to be the same account as sql service by sp_xp_cmdshell_proxy_account 'box\sql_service', 'pwd here'
when i'm running from my login, sysadmin, xp_cmdshell 'dir \\myshare.file.core.windows.net\myshare'
everything is good
when i'm running from "app" login, no sysadmin, getting the error The user name or password is incorrect.
, even though, now it runs the command under same user on the box
Upvotes: 0
Views: 625