|
Home > Archive > MS SQL Server Connectivity > January 2006 > SQL Agent cannot start
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Agent cannot start
|
|
| Somchai 2006-01-10, 9:23 am |
| I have a Window 2003 SBS with SQL installed (SQL 2000 includet in SBS).
Everything worked fine for a long time, but now the SQL server starts but the
SQL agent doesn't start even manually. When I try to start the agent it is
trying to connect but it doesn't. In the log it says that it started but
immediately stoped again. What could cause this, how do I get to start the
agent again?
Thanks for your help
Somchai
| |
| Andrew J. Kelly 2006-01-10, 11:23 am |
| Often times this is due to the fact the account the agent is running under
does not have all the proper permissions or authentications. Has anything
been done to that account recently? If you change it or even redo the
account make sure you do it thru Enterprise Manager and not directly thru
the service.
--
Andrew J. Kelly SQL MVP
"Somchai" <Somchai@discussions.microsoft.com> wrote in message
news:4C581F83-4F73-4FC5-9F87- 621E483731C6@microso
ft.com...
>I have a Window 2003 SBS with SQL installed (SQL 2000 includet in SBS).
> Everything worked fine for a long time, but now the SQL server starts but
> the
> SQL agent doesn't start even manually. When I try to start the agent it
> is
> trying to connect but it doesn't. In the log it says that it started but
> immediately stoped again. What could cause this, how do I get to start
> the
> agent again?
>
> Thanks for your help
>
> Somchai
|
|
|
|
|