SQLAgent can't up

[Saiyou Anh]

I have two questions:
(1)After I stopped SQLAgent, I couldn't start it up, even restart the
server.Why?
(2) I may need to reinstall the server, if I do, do I need to
uninstall? or just override the current one?
Thanks!
Saiyou

[Greg D. Moore \(Strider\)]

Re: SQLAgent can't up


"Trevor Best" <bouncer@localh ost> wrote in message
news:k6fqjvg50i ko08l5b2uil38ds 8q7ha78p1@4ax.c om...[color=blue]
> On 15 Aug 2003 12:45:45 -0700 in comp.databases. ms-sqlserver,
> wangc@alexian.n et (Saiyou Anh) wrote:
>[color=green]
> >I have two questions:
> >(1)After I stopped SQLAgent, I couldn't start it up, even restart the
> >server.Why?[/color]
>
> Restart the server or just the SQLServer service? If a service doesn't
> start then the reason is usually logged in the event log, have you
> looked there?
>[color=green]
> >(2) I may need to reinstall the server, if I do, do I need to
> >uninstall? or just override the current one?[/color]
>
> Don't think that far ahead, it's not crunch time... yet.[/color]

My guess is btw.. that the user password changed (the user that SQL Agent
runs under).

Or someone changed the account, but hadn't cycled SQL Agent yet.

[color=blue]
>
> --
> Ride Free (but you still have to pay for the petrol)
>
> (replace sithlord with trevor for email)[/color]