Re: SQL Agent Account log on

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/30/05 

Date: Mon, 29 Aug 2005 17:46:51 -0600

Then another thing to check would be the job owner. Make
sure it's a member of the sysadmin role so that it's
actually executing under the Agent service credentials.

-Sue

On Mon, 29 Aug 2005 08:33:18 -0500, "Greg Kasprzycki"
<gregkasp@gmail.com> wrote:

>i tried it, and it works just fine, so looks like the security it ok, there
>must be something else what happens when the exe is called by the job.
>
>Greg
>
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:sal4h15f2l7pqugb2lug2omidg2b7h2q4u@4ax.com...
>> You may want to try logging onto the server using the domain
>> account you are trying to have SQL Agent run under. Try
>> executing the exe and see if you get any errors, dialog
>> boxes popping up, etc.
>>
>> -Sue
>>
>> On Thu, 25 Aug 2005 14:38:01 -0500, "Greg Kasprzycki"
>> <gregkasp@gmail.com> wrote:
>>
>> >Hi
>> >
>> >my client is having problem with SQLServerAgent. One of the jobs is
>calling
>> >an EXE (vb6) to generate crystal report. When running under local admin
>it
>> >works fine, when running under domain account (which is also member of
>local
>> >admin) it does not work correctly. It creates export file (report in pdf)
>> >however, it is empty.
>> >
>> >thanks
>> >Greg
>> >
>>
>

Relevant Pages

  • RE: Distibution db cleanup will not run
    ... The 'sa' could be the owner of the agent ... right-click the job 'distribution clean up: ... 'xp_cmdshell' to READ and WRITE the directory instead of the job owner. ...
    (microsoft.public.sqlserver.replication)
  • RE: DEADLOCKED IN SQL SERVER REPLICATION
    ... When the cleanup agent is executing, ... The distribution agent has detected an error. ... How can I solve the deadlock between the distribution agent and the cleanup ...
    (microsoft.public.sqlserver.replication)
  • Re: Distribution Agent Issue
    ... Job owner is distributor_admin. ... agent is not pushing data. ... I have second scenario where on another server Log Reader shows the status ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • RE: unable start any agent?
    ... Go to the underlying job of the agent. ... has to do with the job owner or something. ...
    (microsoft.public.sqlserver.replication)