Is there any "general" reason the sql server agent will stop by itself after
running for 15-30 seconds. Each time I start the service, it will shut it
self down - without error. The application logs simply shows the service
was started and then stopped - reporting no error.

The next step is to try to reinstall SQL, but until someone can be there
onsite @ the server tomorrow, I'm looking for other things to try today.
Thanks!

Hi

You could check the SQLServer error log and the Agent Log File for any
additional information.

John

"Tom L" <tlanger_n05p4m_dls.net> wrote

I'm having some what of a similiar issue where The Agent
said it was started but when you would look at the jobs
in SQL it wouldn't let you into the properties because it
said the agent is still starting. This is an NT box with
SQL 7 and I have Backup Exec running as well. What I
found is that if I re-installed Backup Exec it Re-
installed the MDAC and the problem went away. I'm really
not sure why this became an issue but it worked.

The most likely problem is the id you are using to start the SQL Server
Agent. I have seen this a lot. Either you have the password wrong, or the
id you are using doesn't have rights to start a service, etc. Try using the
LocalSystem account to verify that it is the id causing you grief.

Try using a different id / pw. But, the other guy is right. Check your SQL
Server Agent error log right after you get a failure.

David Pless

"Tom L" <tlanger_n05p4m_dls.net> wrote