大网数据广告活动
数据库与应用安全

Agent Service Fails to Start on Standalone Server

· 52CE 我爱测

Provides resolutions for the problems where the SQL Server service and the SQL Server Agent service might not start on a stand-alone server.

This article helps you resolve the problems where the SQL Server service and the SQL Server Agent service might not start on a standalone server.

Original product version:   SQL Server
Original KB number:   307288

Symptoms

  • Issue 1: On a standalone server, the MSSQLSERVER service might fail to start, and you receive the following error message:

    An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the MSSQLServer Service.
    
  • Issue 2: Similarly, the SQLServerAgent service might also fail to start, and you receive the following error message:

    An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the SQLServerAgent Service.
    

    Issue 1 and Issue 2 occur when both of the following conditions are true:

    • The server computer is in a workgroup and not part of a domain.
    • Both the MSSQLSERVER and SQLServerAgent services are set to use a domain account for the startup.
  • Issue 3: On a domain member server, the MSSQLSERVER service might not start during the server start, and you receive the following message in Event Viewer with event id 7038:

    The MSSQLSERVER service was unable to log on as domain\mssqlsvc with the currently configured password due to the following error: Source: NetLogon Description: There are currently no logon servers available to service the logon request. The MSSQLSERVER service terminated unexpectedly.
    

    This problem occurs when all the following conditions are true:

    • The server is part of a domain.
    • Both the MSSQLSERVER and SQLServerAgent services are set to use a domain account for the startup.
    • The startup mode for the MSSQLSERVER and SQLServerAgent is set to Automatic.

Cause

Issue 1 and Issue 2 occur because the server is a standalone computer and the NetLogon service doesn't start on the server. Hence, no domain-wide logon authentications are possible.

Issue 3 occurs because SQL Server services try to start before NetLogon service starts.

Resolution

  • To fix Issue 1 and Issue 2, follow these steps:

    1. Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the local system account.
    2. Restart the server.

    [!NOTE] On a standalone computer, the NetLogon Service should be set for manual startup.

  • To fix Issue 3, use the following workarounds:

    • Configure the SQL Server startup to delayed start for particular Windows servers. Other Windows services such as NetLogon complete first and SQL Server starts without problems.

    • Configure the SQL Server startup to retry. The startup can be completed on the second startup attempt.

    • Change the Duplicate Address Detection (-DadTransmits) value to 1 for all network interfaces on the server. See the command Set-NetIPInterface for more information.

    • Change the Recovery options for SQL Server and SQL Server Agent services. Specify Restart the service as action for the failure options. You can perform this option from the Services applet of Administrative Tools using the familiar Service Control Manager interfaces.

    If the delayed start option can't fix Issue 3, add the following dependencies to the SQL Server service:

    • Ip helper service
    • Server Service
    • Network list service

    You can add the dependencies by using the following commands. The following example assumes a default SQL Server instance MSSQLSERVER. For a named instance, use MSSQL$INSTANCENAME:

    sc.exe qc MSSQLSERVER ::view dependencies
    sc.exe config MSSQLSERVER depend=iphlpsvc/LanmanServer/netprofm
    sc.exe qc MSSQLSERVER ::view dependencies
    

    The first and third commands display the dependencies before and after the change.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 01/16/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。