Service Pack 2 Installation Failure from 12.1.4457.0

• Sean Perkins

  Ten Centuries

  Points: 1377

  More actions

  August 25, 2016 at 4:23 pm

  #329310

  During our recent monthly maintenance window I ran into an error installing SP2 on SQL 2014. The following is a screenshot and the associated error messages. Let me know if you need anything more.

  Here is a list of things that I've tried:

• Tried installing CU7 - failed with similar message
• Tried installing CU8 - failed with similar message
• Restarted Server each time and tried installing CU7, CU8, and SP2 - all failed with similar message



Action required:

Use the following information to resolve the error, and then try the setup process again.

Feature failure reason:

An error occurred during the setup process of the feature.

Error details:

Error installing SQL Server Database Engine Services Instance Features

The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory.

Error code: 0x851A0043

Visit to get help on troubleshooting.

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

Start time: 2016-08-17 22:24:58

End time: 2016-08-17 22:35:14

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

Start time: 2016-08-17 22:34:31

End time: 2016-08-17 22:35:10

Requested action: Patch

Machine Properties:

Machine name: MyServer

Machine processor count: 4

OS version: Windows Server 2012

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 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Database Engine Services 1033 Standard Edition 12.1.4457.0 No Yes

SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server Replication 1033 Standard Edition 12.1.4457.0 No Yes

SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Standard Edition 12.1.4457.0 No Yes

SQL Server 2014 Management Tools - Basic 1033 Standard Edition 12.2.5000.0 No Yes

SQL Server 2014 Management Tools - Complete 1033 Standard Edition 12.2.5000.0 No Yes

SQL Server 2014 Client Tools Connectivity 1033 Standard Edition 12.2.5000.0 No Yes

SQL Server 2014 Integration Services 1033 Standard Edition 12.2.5000.0 No Yes

Package properties:

Description: Microsoft SQL Server 2014

ProductName: SQL Server 2014

Type: RTM

Version: 12

SPLevel: 2

KBArticle: KB3171021

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

PatchType: SP

AssociatedHotfixBuild: 0

Platform: x64

PatchLevel: 12.2.5000.0

ProductVersion: 12.0.2000.8

GDRReservedRange: 12.0.2200.0:12.0.2290.0;12.0.4200.0:12.0.4299.0;12.0.4830.0:12.0.4880.0

Installation location: f:\8f43c516bd4e8b21e2d15d5e2827170c\x64\setup\

Updated product edition:

Instance Edition

MSSQLSERVER Standard

User Input Settings:

ACTION: Patch

ALLINSTANCES: false

CLUSTERPASSIVE: false

CONFIGURATIONFILE:

ENU: true

ERRORREPORTING: false

HELP: false

IACCEPTSQLSERVERLICENSETERMS: true

INDICATEPROGRESS: false

INSTANCEID: <empty>

INSTANCENAME: <empty>

QUIET: false

QUIETSIMPLE: false

SQMREPORTING: 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\120\Setup Bootstrap\Log\20160817_222447\SystemConfigurationCheck_Report.htm


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.