Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-06-06 : 12:55:19
|
| The SQLServerAgent service on 2 of my 8 SQL Servers is not starting. When I try to start the service, this message is displayed."The SQLServerAgent on MyServer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance logs and the Alerts service."All SQL Servers are using the same account to start the service, so its weird that only 2 are affected.Any ideas?Thanks,RaySS2K |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-06 : 16:19:48
|
| Look in the Application Log in Event Viewer for the specific error message that tells you why it won't start.Tara |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-06-07 : 12:41:09
|
| Thanks Tara! Seems like the the problem occurred because the network team changed the account that runs the service. They corrected their modifications and 1 of the services started. The other service is awaiting a server reboot. Thanks again.- ray |
|
|
|
LeoW
Starting Member
1 Post |
Posted - 2005-11-29 : 17:04:38
|
| I have the same problem with my SQL Server 2005 installation. Everything was ok while the Agent logged in using Local System account. As soon as I changed it to the domain account, it stopped almost immediately. There is no indication re what's wrong in the log files or the .OUT file. Agent XPs option is set to O. I explicitely set it to 1, but it got reset back to 0 in about 4 minutes. Any ideas? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-29 : 17:20:07
|
| Leo,Which log files did you look at? Also, it is best to start a new thread on this.Tara Kizeraka tduggan |
|
|
|
|
|
|
SQLServerAgent service won't start