Error 1068 - The dependency service or group failed to start - When Run Manually SQL Server Agent Services

Apply To:
* Microsoft SQL Server 2000

* * * * *

First Condition:
In "Control Panel > Performance and Maintenance > Administrative Tools > Services"

(1).
When want to start manually for Services "SQL Server Agent"
there is an error:

"The dependency service or group failed to start"

and

"An Error 1068 - (The dependency service or group failed to start.) 

occured while performing this service operation on the SQLServerAgent service."

(2).
When want to start manually for Services "SQL Server"
there is an error:

"The service did not start due to a logon failure."

and

"An Error 1069 - (The service did not startd due to logon failure.) 

occured while performing this service operation on the MSSQLServer service."

Checking:
(1).
Checking for Services "SQL Server Agent" :
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"
* Choose, example "SQL Server Agent (SQLSVR_1)"
* Then right-click, choose "Properties"
* Go to Tab "Dependencies"

* Results: There is a dependency to another component services ( SQL Server - SQLSVR_1 )


(2).
Checking for Services "SQL Server" :
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"
* Choose, example "SQL Server (SQLSVR_1)"
* Then right-click, choose "Properties"
* Go to Tab "Dependencies"

* Results: There is a dependency to another component services ( SQL Server Agent - SQLSVR_1 )


Solution:
(1).
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"
* Choose, example "SQL Server Agent (SQLSVR_1)"
* Then right-click, choose "Properties"
* Go to Tab "Log On"
* Make sure for the correct password

* Choose "Apply"
* Then "OK"

(2).
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"
* Choose, example "SQL Server (SQLSVR_1)"
* Then right-click, choose "Properties"
* Go to Tab "Log On"
* Make sure for the correct password

* Choose "Apply"
* Then "OK"


Results:
(1).
* Try to start again manually for Services "SQL Server Agent"
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"

(2).
* Only check,
* Go to "Control Panel > Performance and Maintenance > Administrative Tools > Services"