The SQLServerAgent service on the local computer is stopped again after it is started.

[Error description]
When qlserveragent is started, the following message is displayed:

"The SQLServerAgent service on the Local Computer stops again after it is started. Some services are automatically stopped if they have nothing to do, such as the 'performance logging and alerting 'service ."

SQLServerAgent cannot be started in services, enterprise managers, and service managers.
Server, and then start SQLSERVERAGENT. After this, all services are successfully started, but the service will be automatically disabled later. If the SQLServerAgent service is not running, tasks such as database maintenance plans cannot be executed.

[Solution]

1. Select "use Windows NT fiber.

Solution:
Enterprise Manager -- Right-click SQL instance -- properties -- Processor -- unselect "use Windows
And then restart the SQL service.

2. delete or modify the account and password of the system or SQL statement.

Solution:
A. My computer -- control panel -- Management Tools -- services -- Right-click MSSQLServer -- properties -- login identity -- select "Local SYSTEM account"

Or:

B. My computer -- control panel -- Management Tools -- services -- Right-click
MSSQLServer -- properties -- login identity -- select "this account" -- select administrator, enter your password and confirm your password
Administrator Password (create an account with administrator permissions, such as SA ).

(The difference between the two is: select the first method, and modify the administrator password later. You do not need to adjust the password, but the system administrator is required to log on to the operating system)

C. When A and B are ineffective, choose Enterprise Manager> Manage> right-click SQL
Server proxy -- properties -- connection -- use SQL Server for authentication and enter SQL
Server administrator privilege account and password -- OK (check the settings in each label ).

[Others]
For other factors found, such as illegal shutdown and damage, the Registry needs to be rebuilt and the database needs to be reinstalled.
Solution:

 
Use the installation CD to reinstall the registry, select 'advanced option'-'rebuild registry ', and then proceed all the way ......