December 9, 2015 at 9:52 am
I'm having an issue with permissions. I am running SQL Server Agent under a domain account. The account is a local administrator. When I attempt to run an FTP get session, I cannot write the files to the file system; however, when I run the same batch file for the FTP as a scheduled Task, I have no issues. I somehow cannot figure out how the security context is different.
December 10, 2015 at 8:00 am
does the account have write permission to the file location? Sometimes local admin doesn't always mean account has free reign over everything.
another option instead of adding permission to the AD account, you can add permission on the file location to "NT Service\SQLSERVERAGENT". This way, if you change the agent service account, permissions will not be lost.
you can check the user account context by adding "echo %username% > c:\temp\username.txt" to your batch file. this should tell you the context your job is running in.
December 10, 2015 at 8:03 am
Make sure no proxy is set and ensure that the job itself has the account correctly chosen. There are various ways to change this, and configure different accounts for a job.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 10, 2015 at 8:29 am
Thanks for the help. I granted SQLSERVERAGENT rights to the needed directories and it now runs.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply