SQL Server 开机无法自动启动 MSSQLSERVER服务,可以手动启动,如何解决?

MSSQLSERVER开启的情况下,重启计算机,MSSQLSERVER服务不会自动启动,每次开机必须手动启动服务。
查询开机时间附近的日志:

img


Id = {00000000-0000-0000-0000-000000000000};ClientMachine = SHARVEPC;用户 = SHARVEPC\HP;ClientProcessId = 10628;组件 = Unknown;操作 = Start IWbemServices::ExecMethod - root\Microsoft\SqlServer\ComputerManagement15 : \SHARVEPC\root\Microsoft\SqlServer\ComputerManagement15:SqlService.ServiceName="MSSQLSERVER",SQLServiceType=1::StartService;ResultCode = 0x8007041C;PossibleCause = Unknown

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="Microsoft-Windows-WMI-Activity" Guid="{1418ef04-b0b4-4623-bf7e-d74ab47bbdaa}" /> 
  <EventID>5858</EventID> 
  <Version>0</Version> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Opcode>0</Opcode> 
  <Keywords>0x4000000000000000</Keywords> 
  <TimeCreated SystemTime="2022-04-06T12:20:35.6802963Z" /> 
  <EventRecordID>8408</EventRecordID> 
  <Correlation /> 
  <Execution ProcessID="2908" ThreadID="3964" /> 
  <Channel>Microsoft-Windows-WMI-Activity/Operational</Channel> 
  <Computer>SharvePC</Computer> 
  <Security UserID="S-1-5-18" /> 
  </System>
- <UserData>
- <Operation_ClientFailure xmlns="http://manifests.microsoft.com/win/2006/windows/WMI">
  <Id>{00000000-0000-0000-0000-000000000000}</Id> 
  <ClientMachine>SHARVEPC</ClientMachine> 
  <User>SHARVEPC\HP</User> 
  <ClientProcessId>10628</ClientProcessId> 
  <Component>Unknown</Component> 
  <Operation>Start IWbemServices::ExecMethod - root\Microsoft\SqlServer\ComputerManagement15 : \\SHARVEPC\root\Microsoft\SqlServer\ComputerManagement15:SqlService.ServiceName="MSSQLSERVER",SQLServiceType=1::StartService</Operation> 
  <ResultCode>0x8007041c</ResultCode> 
  <PossibleCause>Unknown</PossibleCause> 
  </Operation_ClientFailure>
  </UserData>
  </Event>

请教如何设置开机自动启动MSSQLSERVER服务。

把服务设置成 “自动(延迟启动)”试试

img

一般开发的机器,会设置为手动开启。可以的话,重装一下。