Re: SQL Agent Account log on

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

Date: Tue, 30 Aug 2005 12:55:33 -0500

It just got more interesting. We tried exporting to XML instead of PDF, and
it worked just fine

Greg

"Greg Kasprzycki" <gregkasp@gmail.com> wrote in message
news:OsfWuDWrFHA.904@tk2msftngp13.phx.gbl...
> 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: Job Offer in Paris, France : R&D Engineer (Plone)
    ... > If you are a member of the EU, ... French pretty well at that time, and could converse ok if the other ... I have most of the qualifications in the pdf (I've been ... and dont hesitate to apply if you are ...
    (comp.lang.python)
  • Re: Simtec v Castle USB
    ... Microsoft is a member of numerous ... >> industry groups and standards bodies, precisely so they can claim their ... Greg, go read up on it, your understanding is lacking. ...
    (comp.sys.acorn.hardware)
  • Re: HP cross refernce wanted for 1820-0379
    ... Thanks Greg - the PDF is 3Meg so I will send it seperately to the ... spreadsheet - 363K ... BTW for any possible Volunteers if you dont have excel I can tell you how to ...
    (sci.electronics.equipment)
  • Re: For Don - Crime in the North
    ... Greg always disparages groups he is a member of, from the third party ...
    (rec.scuba)
  • Help with CL Move File Command
    ... What command can I use to move a member from a regular library/file to ... In this case, the lib/file/member is a PDF document, and it is in ASCII ... I wish to move the member to an IFS folder which is shared on the ...
    (comp.sys.ibm.as400.misc)