Windows 10: UPDATE FAILED:Security Update for SQL Server 2016 Service Pack 1 GDR (KB4458842) - Error...

UPDATE FAILED:Security Update for SQL Server 2016 Service Pack 1 GDR (KB4458842) - Error 0x80070002.?

:)

 

Security Update for SQL Server 2014 Service Pack 1 GDR (KB4019091) - error 0x80070643

Hello!

I have Windows 10 (64-bits) and SQL Server 2014 Installed, but when it had try to install the Service Pack 1 GDR (KB4019091) security update then throw this error: 0x80070643.

Anybody could help me?

 

Windows Update for SQL Server 2016 Service Pack 1 GDR (KB4019089) Fails.

I am trying to get a security update installed via windows update and the installation fails. It reads:

There were problems installing some updates, but we'll try again later. If you keep seeing this and want to search the web or contact support for information, this may help:

• Security Update for SQL Server 2016 Service Pack 1 GDR (KB4019089) - Error 0x80070643

After much googling I found this page which I believe (but am not sure) relates to my problem:

https://support.microsoft.com/en-us...ative-update-1-for-sql-server-2016-fails-on-a

It states that to resolve the issue I should install latest sql 2016 server build. I downloaded the latest here: https://www.microsoft.com/en-us/download/details.aspx?id=54613

Cumulative Update Package 7 for SQL Server 2016 SP1 - KB4057119 for reference.

But under the installation it fails under that last step "Completed with Errors". It says the 2 features Database Engine Services (MSSQLSERVER) and Reporting Services - Native (MSSQLSERVER) have a status of failed. I am assuming because they are already
installed?

The log file shows the following:

Overall summary:

Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.

Exit code (Decimal): -2068052374

Start time: 2018-02-02 10:45:03

End time: 2018-02-02 10:46:40

Requested action: Patch

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): -2068052374

Start time: 2018-02-02 10:46:07

End time: 2018-02-02 10:46:36

Requested action: Patch

Machine Properties:

Machine name: DESKTOP-HS0F2TN

Machine processor count: 8

OS version: Microsoft Windows 10 Pro (10.0.16299)

OS service pack:

OS region: Canada

OS language: English (United Kingdom)

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 Developer Edition 13.1.4206.0 No Yes

SQL Server 2016 MSSQLSERVER MSRS13.MSSQLSERVER Reporting Services - Native 1033 Developer Edition 13.1.4001.0 No Yes

SQL Server 2016 SSMS 1033 13.0.15000.23 No Yes

SQL Server 2016 Adv_SSMS 1033 13.0.15000.23 No Yes

SQL Server 2016 LocalDB 1033 Express Edition 13.1.4466.4 No Yes

Package properties:

Description: Microsoft SQL Server 2016

ProductName: SQL Server 2016

Type: RTM

Version: 13

SPLevel: 1

KBArticle: KB4057119

KBArticleHyperlink: http://support.microsoft.com/?kbid=4057119

PatchType: QFE

AssociatedHotfixBuild: 0

Platform: x64

PatchLevel: 13.1.4466.4

ProductVersion: 13.1.4001.0

GDRReservedRange: 13.0.1700.0:13.0.1899.0;13.0.4200.0:13.0.4299.0

Installation location: C:\950dec1d20077bf0d9ef5f65a498\x64\setup\

Updated product edition:

Instance Edition

MSSQLSERVER Developer

User Input Settings:

ACTION: Patch

ALLINSTANCES: false

CLUSTERPASSIVE: false

CONFIGURATIONFILE:

ENU: false

HELP: false

IACCEPTROPENLICENSETERMS: false

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\20180202_104500\SystemConfigurationCheck_Report.htm

I am unsure how to resolve the problem and or tell windows to stop trying to install this update if no further action is required. Can anyone help me address this issue or is a non issue I should ignore? If so how do I tell windows update to stop trying
to install this update?

Thanks so much for your time.

/Chris

 

SQL Server 2016 Service Pack 1 generally available

Source: SQL Server 2016 Service Pack 1 generally available | SQL Server Blog