May 11, 2011 at 6:30 am
I'm trying to schedule a job in sql 2008 to run an exe.
Open sql server agent, start to set up the new job and when i get to the point where i'm creating the step, i select operating system (cmdexec) and under run as sql server agent service account is selected - and it's the only option available.
when i click on open and navigate to the exe file and select it, i get the error that access to the path (path to the exe file) is denied. I've given both the SQLServer account and the SQLServerAgentUser account full control over the directory - no effect on the error.
Can someone tell me step by step what i need to do to get this working? I've done some googling and looks like i might need to create a proxy account, and a credential for that proxy. But I want to make sure that's correct, and that I do it correctly. I tried setting one up myself using my own win2k8 admin account login for the credential, but i still get the same error.
May 12, 2011 at 12:27 am
hmm - so if i manually type in the path to the exe file, it works. it's only when i try to select it by browsing to it that i get the error.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply