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 |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2005-07-14 : 10:36:18
|
| I can't get the SQLServerAgent service to stay running on my server... which was just upgraded to XP Pro. It used to run fine on Win2K Pro...Any thoughts? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-14 : 12:02:06
|
| Anything in the Event Log?Kristen |
 |
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2005-07-14 : 12:12:22
|
| Yes:SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start).However, my applications can access the server just fine (both run locally ON the server, and from other machines.I'm using MSDE 1.0, but I think the SQLServerAgent is the same as in full-blown SQL Server.BTW the MSSQLServer service starts and runs just fine. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-14 : 12:30:22
|
| has the UserID/Password which SQLServerAgent is set up to start with changed / expired / become duff?Kristen |
|
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2005-07-15 : 08:22:23
|
| Well, I just tried this with the service set to use a specific name and password (mine, and I am set up as an administrator on the machine) instead of the local system account. Same result - it starts but then stops, the event log simply shows that it can't connect to the server.Wondering if this has something to do with DCOM? Dunno. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 08:34:33
|
| I'm Stumped, sorry |
|
|
|
|
|
|
SQLServerAgent service won't start