Saturday, March 02, 2013 7:24 PM
I added a proxy account with domain user based on following link
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.
- Edited by Parry2k Saturday, March 02, 2013 7:24 PM
Saturday, March 09, 2013 4:19 PMModerator
The following article has the answer for you:
Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012