when i execute the SQLCMD using my credential, it works fine. but whjen i put the same command in a SQL job and run it,
it fails with Access denied error.
yes i do have xp_cmdshell enabled. All i see in the job log is Access denied. Its does not say anything else.
The account under which sql agent job is running will not have appropriate permission to do so, so you need to elevate the permission for your sql agent job account.
You need to setup a proxy account and run the job using that proxy account
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?