Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the problem that the SQL Agent service cannot be started, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Problem phenomenon

The following is the Syslog and SQL Agent log

The copy code is as follows: SQLServerAgent could not be started (reason: unable to connect to the server "(local); SQLServerAgent cannot be started)

2016-05-20 11:09:03-[100] Microsoft SQLServerAgent version 11.0.3000.0 (build number X64 unicode Retail): process ID 35682016-05-20 11:09:03 -? [495] the SQLServer agent startup service account is WORKGROUP\ iZ23egtmtrmZ$. 2016-05-20 11:09:03 -! [150] SQL Server does not accept connections (error: 18456). Please wait for SQL Server to allow the connection. The attempted action is to verify the connection at startup. 2016-05-20 11:09:03 -! [000] unable to connect to the server "(local)"; SQLServerAgent could not start 2016-05-20 11:09:03 -! [298] SQLServer error: 18456, user'NT AUTHORITY\ ANONYMOUS LOGON' login failed. [SQLSTATE 28000] 2016-05-20 11:09:03 -! unable to log in to server "(local)" (DisableAgentXPs) 2016-05-20 11:09:03 -? [098] SQLServerAgent terminated (General)

Solution:

In the registry, navigate to the ServerHOST property of SQL Agent:

The copy code is as follows: HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Microsoft SQLServer\ MSSQL11.SQL2012\ SQLServerAgent\ ServerHost

Where MSSQL.X represents instance information, and its naming convention is: MSSQL version number. Instance name, such as MSSQL11.SQL2012 on my machine, the instance name on your machine may be different, in addition, if you have multiple instances installed on your host, there will be multiple such options, please look up according to the actual situation, or directly use CTRL+F to find the ServerHost keyword.

Double-click to open the ServerHOST property and fill in np:servername under "numerical data"

Where servername is the host name of the server.

Finally, start SQL Server Agent, and it will be fine.

On the SQL Agent service can not start how to share here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.