Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
sp_xmdshell_proxy_account issue

Answered sp_xmdshell_proxy_account issue

  • Saturday, March 02, 2013 7:24 PM
     
     
    Sign In to Vote
    0

    I added a proxy account with domain user based on following link

    http://social.msdn.microsoft.com/Forums/en/transactsql/thread/40d67d22-28ac-44ab-b7d2-0eec25f873a6 

    now if i run a command xp_cmdhshell "whoami.exe" I still get nt authority\network service but not getting proxy account.

    Also I created ssis package which copy file from one server to another server, if I run this ssis package from command prompt it works fine but if I run this SSIS package from SSMS, I get "access denied" on server folder from where I'm copying the file.

    I was thinking with proxy account which has permission to the server folder, will work.

    Can someone help me what I'm doing wrong or if there is anything else I'm missing in this process.

    thanks,

    p

    • Edited by Parry2k Saturday, March 02, 2013 7:24 PM
    •  
     

All Replies