none
SQLCMD is having Access denied error.

    Question

  • 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.


    Tuesday, July 09, 2013 1:24 AM

Answers

  • 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.

    OR 

    You need to setup a proxy account and run the job using that proxy account


    Regards Harsh

    Tuesday, July 09, 2013 4:22 AM