Job and Exe

1 Sep 2006 9:25 PM

CLM

Let's say you have a Sql Server Agent job (on 2000) that runs an executable,
i.e. a .exe and is failing because it does not have permission to the folder.
Here are my questions:

1. What permissions does Sql Server Agent run under, the permissions of the
Sql Server agent itself?
2. Will the executable run under the permissions of the logged in user to
the box or under the permissions of the Sql Server Agent or both?
3. Any comments/suggestions?

1 Sep 2006 9:47 PM

Arnie Rowland

I'm a bit 'fuzzy' on this, but as I recall...

With SQL 2000, SQL Agent Jobs run under the SQL Agent security
account -UNLESS a proxy account has been established. CmdExec (xp_cmdshell)
steps require sysadmin (local administrator) level privileges.

Jobs can only be managed by the job owner or sysadmin role.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"CLM" <C**@discussions.microsoft.com> wrote in message
news:D9A8C126-F78D-4807-B824-C4EEDD32ABB1@microsoft.com...
> Let's say you have a Sql Server Agent job (on 2000) that runs an
> executable,
> i.e. a .exe and is failing because it does not have permission to the
> folder.
> Here are my questions:
>
> 1. What permissions does Sql Server Agent run under, the permissions of
> the
> Sql Server agent itself?
> 2. Will the executable run under the permissions of the logged in user to
> the box or under the permissions of the Sql Server Agent or both?
> 3. Any comments/suggestions?

1 Sep 2006 10:57 PM

Andrew J. Kelly

These should explain it. Even though the firstone used DTS the principles
are the same:

http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a
Scheduled Job
http://www.support.microsoft.com/?id=890775 How to enable no sa's to run
xp_cmdshell

--
Andrew J. Kelly SQL MVP

Show quote

"CLM" <C**@discussions.microsoft.com> wrote in message
news:D9A8C126-F78D-4807-B824-C4EEDD32ABB1@microsoft.com...
> Let's say you have a Sql Server Agent job (on 2000) that runs an
> executable,
> i.e. a .exe and is failing because it does not have permission to the
> folder.
> Here are my questions:
>
> 1. What permissions does Sql Server Agent run under, the permissions of
> the
> Sql Server agent itself?
> 2. Will the executable run under the permissions of the logged in user to
> the box or under the permissions of the Sql Server Agent or both?
> 3. Any comments/suggestions?