Can't upgrade SQL Server 2016 SP2-CU15-GDR to 2016SP3-KB5003279

Question

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)

Answer 1

Please try to repair your SQL Server installation using instructions provided here. After that try to apply the update again.

There is also a known issue when updating SQL Server 2016 as described here.

Could you please open Services (run services.msc) and make sure the "SQL Server" service has status "running"?

Answer 2

unfortunately, the repair process is not successful, I have continued with the below error.

and it's stuck here,

and it's completed with Database engine services failed (status) [Rest of the features are succeed]

All the services are fine

after that, I retried the upgrade process but the same issue occurred.

Answer 3

An issue has been resolved with the below steps:

1. Changed SQL Server Service and SQL Server Agent Service to ‘Local System’
2. Reboot the PC
3. Repair the SQL Server Instance [System displayed the below error message] by the latest ISO (enu_sql_server_2016_developer_edition_with_service_pack_3_x64_dvd_ceaed495.iso)
   
4. Open SQL Server configuration manager and start all the required Services.
   
5. Closed the above error and continue
6. Repair process completed with the below warning
   
7. Update database default location, [Previously it was D:\Log] which was not a valid location.
   
8. Reboot the Computer
9. Install SQLServer2016SP3-KB5003279-x64-ENU
10. Reboot the system
11. Verified the version
    

Answer 4

Hello

Thank you for your question and reaching out. I can understand you are having issues related to SQL server upgrade.

Please backup Registry and verify the value at HKEY_LOCAL_MaCHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState

The values for all the keys under this should be 1. If it is not 1, then there is some issue in configuring the corresponding feature.

Fix the feature configuration issue or edit the registry to change the value to 1 to install the patch.

Disable any Antivirus program or Windows firewall you may have for temporary purpose

View and Read SQL Server Setup Log Files: http://msdn.microsoft.com/en-us/library/ms143702(v=sql.110).aspx.

----------------------------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--