Re: SQL Agent Account log on
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/31/05
- Next message: Sue Hoegemeier: "Re: Create table rights"
- Previous message: jaylou: "Re: Create table rights"
- In reply to: Greg Kasprzycki: "Re: SQL Agent Account log on"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Aug 2005 17:30:38 -0600
Then I'd guess it was something with the install path or how
the installation of the client pieces for crystal were
installed.
-Sue
On Tue, 30 Aug 2005 12:55:33 -0500, "Greg Kasprzycki"
<gregkasp@gmail.com> wrote:
>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
>> > >> >
>> > >>
>> > >
>> >
>>
>>
>
- Next message: Sue Hoegemeier: "Re: Create table rights"
- Previous message: jaylou: "Re: Create table rights"
- In reply to: Greg Kasprzycki: "Re: SQL Agent Account log on"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|