Re: SQL Agent Account log on

From: Greg Kasprzycki (gregkasp_at_gmail.com)
Date: 08/30/05 

Date: Tue, 30 Aug 2005 07:47:06 -0500

we tried using sa or another user who is also member of sysadmin, didn't
help

greg

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:dg77h19ea2q85bujceq0scbasaa3uho6tu@4ax.com...
> 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: securityadmin server role - change password
    ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... editable for members of the SecurityAdmin role. ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)
  • Re: securityadmin server role - change password
    ... In Enterprise Manager (I assume that passwords are changed via ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Agent - Job HELL
    ... "A user who is not a member of the sysadmin role can use sp_start_job to ... the job to first check the flag before performing any actual work. ... as the SQL Server Agent proxy account. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 7 Permissions!
    ... SQL Server MVP ... > The user is the user I'm using and is not sysadmin. ... Or member of the Windows Administrators ...
    (microsoft.public.sqlserver.security)