Re: SQLAGENT$SQLMONITORING wont start at reboot
- From: "Paul Shapiro" <paul@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 15 Sep 2006 10:39:02 -0400
I'm sorry that I don't remember the details, but I think there is sometimes
an issue with timing and the startup of other services which the SQL Agent
depends on. I think I fixed it once by adding a dependency on another
service. You can look at the list of service startup messages in the event
log and pick a late-starting one if you can't determine the necessary one.
Paul Shapiro
"John C. Pratt" <John C. Pratt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48B9CBED-AE1B-4D1A-A7A8-790C65DC3DED@xxxxxxxxxxxxxxxx
I have had the same exact problem on a Win2003 server/SQL Server 2000
Standard install since the machine was put in production. There are 2 SQL
instances on the box, one is disabled and the other is our production
database. The SQL Agent service for the primary, enabled instance is
properly configured in the registry, is set to start Automatically, the
Local
System Adminstrator account is a member of the local Administrators group
which is a member of the Domain Admins group (in AD), and the service
starts
fine if you do it manually. It just won't restart when the server
reboots.
We have 2 other servers (development and staging/test) with the same or
nearly the same config, and both work perfectly.
I will try using a named Domain Admin user rather than the Local System
setting for service login, but I can't test right away. Any additional
info
will be most appreciated.
FYI, this is the only topic I have found on the web covering this exact
problem.
Thanks.
.
- Prev by Date: VPN Problem
- Next by Date: Re: Bridging network segments.
- Previous by thread: VPN Problem
- Next by thread: SBS 2003 Domain / Terminal Server Licensing / Additional SBS on VPN
- Index(es):
Relevant Pages
|
