MSSQLSERVER开启的情况下,重启计算机,MSSQLSERVER服务不会自动启动,每次开机必须手动启动服务。
查询开机时间附近的日志:
- <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服务。
把服务设置成 “自动(延迟启动)”试试
一般开发的机器,会设置为手动开启。可以的话,重装一下。