Hi,
I am trying to upgrade Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 to SP3 (KB5003279) - 13.0.6300.2 but the upgrade process will be stopped with the below error in Azure SQL VM.
but I did not see any issues on Microsoft SQL Server 2016 - System Configuration Check Report
and did not find any solution in the error log too:
Overall summary:
Final result: The patch installer has failed to update the following instance:. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The NT service 'MSSQLSERVER' could not be started.
Start time: 2022-06-08 14:45:42
End time: 2022-06-08 14:55:42
Requested action: Patch
Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.6300.2&EvtType=0xAE7B8BF3%400xF762992B%401202%401&EvtType=0xAE7B8BF3%400xF762992B%401202%401
Instance MSSQLSERVER overall summary:
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The NT service 'MSSQLSERVER' could not be started.
Start time: 2022-06-08 14:50:02
End time: 2022-06-08 14:53:25
Requested action: Patch
Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.6300.2&EvtType=0x0EE19F0D%400xF762992B%401202%401&EvtType=0x0EE19F0D%400xF762992B%401202%401
Machine Properties:
Machine name: X47-DBNODE-01
Machine processor count: 8
OS version: Microsoft Windows Server 2016 Datacenter (10.0.14393)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER Database Engine Services 1033 Standard Edition 13.2.5865.1 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER SQL Server Replication 1033 Standard Edition 13.2.5865.1 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Standard Edition 13.2.5865.1 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER Data Quality Services 1033 Standard Edition 13.0.1601.5 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER R Services (In-Database) 1033 Standard Edition 13.2.5865.1 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER sql_inst_mr 1033 Standard Edition 13.2.5865.1 No Yes
SQL Server 2016 MSSQLSERVER MSRS13.MSSQLSERVER Reporting Services - Native 1033 Standard Edition 13.3.6404.1 No Yes
SQL Server 2016 Client Tools Connectivity 1033 13.0.14500.10 No Yes
SQL Server 2016 Client Tools Backwards Compatibility 1033 13.0.14500.10 No Yes
SQL Server 2016 Client Tools SDK 1033 13.0.14500.10 No Yes
SQL Server 2016 Data Quality Client 1033 Standard Edition 13.2.5026.0 No Yes
SQL Server 2016 Integration Services 1033 Standard Edition 13.3.6404.1 No Yes
Package properties:
Description: Microsoft SQL Server 2016
ProductName: SQL Server 2016
Type: RTM
Version: 13
SPLevel: 3
KBArticle: KB5003279
KBArticleHyperlink: https://support.microsoft.com/?kbid=5003279
PatchType: SP
AssociatedHotfixBuild: 0
Platform: x64
PatchLevel: 13.3.6300.2
ProductVersion: 13.0.1601.5
GDRReservedRange: 13.0.1700.0:13.0.1899.0;13.0.4200.0:13.0.4299.0;13.0.5200.0:13.0.5399.0;13.0.6400.0:13.0.6999.0
Installation location: f:\c3005af301c80222f9c219fa\x64\setup\
Updated product edition:
Instance Edition
MSSQLSERVER Standard
User Input Settings:
ACTION: Patch
ALLINSTANCES: false
CLUSTERPASSIVE: false
CONFIGURATIONFILE:
ENU: true
HELP: false
IACCEPTROPENLICENSETERMS: true
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: <empty>
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20220608_144539\SystemConfigurationCheck_Report.htm
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInvalidOperationException
Message:
The NT service 'MSSQLSERVER' could not be started.
HResult : 0x84b20001
FacilityCode : 1202 (4b2)
ErrorCode : 1 (0001)
Data:
HelpLink.EvtType = 0xAE7B8BF3@0xF762992B@이강헌 @1
DisableWatson = true
Stack:
at Microsoft.SqlServer.Configuration.SetupExtension.RunPatchAllInstanceAction.RestoreServiceStates()
at Microsoft.SqlServer.Configuration.SetupExtension.RunPatchAllInstanceAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)