SQL Agent无法启动 [英] SQL Agent not starting

问题描述

SQL Server代理未在错误日志中以以下错误开头.有人可以帮忙吗?

SQL server Agent not starting with the following errors in the error log. Can anyone help?

[150] SQL Server不接受连接(错误:233).等待Sql Server允许连接.尝试的操作是:验证启动时的连接.
[000]无法连接到服务器(本地)"； SQLServerAgent无法启动
[298] SQLServer错误:26，客户端无法建立连接，因为登录之前的握手期间遇到错误.常见原因包括客户端尝试连接到不受支持的SQL Server版本，服务器太忙而无法接受新连接 或服务器上的资源限制(内存或允许的最大连接数). [SQLSTATE 08001]
[298] SQLServer错误:233，共享内存提供程序:管道的另一端没有进程. [SQLSTATE 08001]
[298] SQLServer错误:26，客户端无法建立连接[SQLSTATE 08001]
[298] SQLServer错误:233，由于预登录失败，客户端无法建立连接[SQLSTATE 08001]
[382]登录到服务器(本地)"失败(DisableAgentXPs)
[098] SQLServerAgent终止(通常)

[150] SQL Server does not accept the connection (error: 233). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.
[000] Unable to connect to server '(local)'; SQLServerAgent cannot start
[298] SQLServer Error: 26, Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server. [SQLSTATE 08001] 
[298] SQLServer Error: 233, Shared Memory Provider: No process is on the other end of the pipe. [SQLSTATE 08001] 
[298] SQLServer Error: 26, Client unable to establish connection [SQLSTATE 08001] 
[298] SQLServer Error: 233, Client unable to establish connection due to prelogin failure [SQLSTATE 08001] 
[382] Logon to server '(local)' failed (DisableAgentXPs)
[098] SQLServerAgent terminated (normally)

尝试过

为帐户NT服务\ SQLSERVERAGENT授予对LOG文件夹的读/写权限

Granting read/write permission to LOG folder for account NT Service\SQLSERVERAGENT

共享内存/命名管道/TCp/IP均已启用

Shared memory/Named Pipes/ TCp/IP all enabled

SQL Server 2016

SQL server 2016 

推荐答案

您好，理查德，

Hi Richard,

这是Azure或本地运行的SQL Server实例吗?

Is this an SQL Server instance in Azure or running on-premise? 

该错误告诉我这是一个在本地运行的SQL Server实例，但是您可能在VM内部运行.您可能要确保SQL Engine进程在此环境中运行.

The error tells me this an SQL Server instance running on-premise but, you could be running inside a VM. You may want to ensure the SQL Engine process is running in this environment.

此致

迈克

这篇关于SQL Agent无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！