MichaelK2
asked on
SQLServer Agent does not automatically start.
I am using SQL server 2008 and it is hosted on a XP Pro SP3 machine.
The XP host is a Vmware "pc'.
The Sql Server Agent never starts automatically upon logon, i have set it start automatically but always have to manually do it. even though it is set to auto. However when i right click on it and click "start" it starts fine. So the password is ok.
In the Event Log it says that "The Sql Server agent could not start for the reason (unable to connect to the server). Event ID 103
The XP host is a Vmware "pc'.
The Sql Server Agent never starts automatically upon logon, i have set it start automatically but always have to manually do it. even though it is set to auto. However when i right click on it and click "start" it starts fine. So the password is ok.
In the Event Log it says that "The Sql Server agent could not start for the reason (unable to connect to the server). Event ID 103
set the startup to automatic (delayed start) or set the dependency service to be the sql server
ASKER
How do i set it to auto (delayed start), it is just on plain auto now.
Also where is the dependency service in SQL?
Also where is the dependency service in SQL?
Just to add to theruck...
You do this in Services.
Locate "SQL Server Agent (SQLSERVER)" in the list and select properties..
You do this in Services.
Locate "SQL Server Agent (SQLSERVER)" in the list and select properties..
ASKER
Yes, i know where to find the services (in the confiiguration manager).
But TheRuck is taliking about auto (delayed start), is that different to just plain auto as i do not see any place to choose "delayed start"'? I just see auto, stopped and disable.
The main sql server service is already set as a dependenciy for the agent service.
But TheRuck is taliking about auto (delayed start), is that different to just plain auto as i do not see any place to choose "delayed start"'? I just see auto, stopped and disable.
The main sql server service is already set as a dependenciy for the agent service.
it depends on what os you have. XP does not have this option. sorry to mislead you
You set auto (delayed start) in General Path (Startup type).
to set dependencies see Set Dependencies
to set dependencies see Set Dependencies
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Srm74 gave the solution.
It was through the link in his suggestion that explained about adding a service through the registry.
I added the Spooler service to the DependOnService and it seemed to the trick.
The Messenger service is always disabled by default and most of the companys I have worked at never use it and have it disabled.
To TheRuck....thanks for trying Bud, but I feel that Srm74 really pointed me in the right direction.
It was through the link in his suggestion that explained about adding a service through the registry.
I added the Spooler service to the DependOnService and it seemed to the trick.
The Messenger service is always disabled by default and most of the companys I have worked at never use it and have it disabled.
To TheRuck....thanks for trying Bud, but I feel that Srm74 really pointed me in the right direction.