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

Source: Internet
Author: User

[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 ......
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.