SQL Server2019 重装失败

Kning 1 Reputation point
2022-04-10T03:40:27.48+00:00

Overall summary:
Final result: 失败: 请查看下面的详细信息
Exit code (Decimal): -2068119551
Exit facility code: 1211
Exit error code: 1
Exit message: 找不到注册表项“SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState”。
Start time: 2022-04-10 11:13:44
End time: 2022-04-10 11:14:13
Requested action: Install
Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xF96176E5%400xD3BEBD98%401211%401&EvtType=0xF96176E5%400xD3BEBD98%401211%401

Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: 使用以下信息解决错误,然后再次尝试运行安装过程。
Next step for Writer: SQL Server 安装程序在完成此操作之前已取消。请再次尝试运行安装过程。

Machine Properties:
Machine name: LAPTOP-4U0BL3OV
Machine processor count: 16
OS version: Microsoft Windows 10 家庭中文版 (10.0.19042)
OS service pack:
OS region: 中国
OS language: 中文(中国)
OS architecture: x64
Process architecture: 64 位
OS clustered: 否

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured

Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: E:\SQL2019\Developer_CHS\x64\setup\
Installation edition: Developer

Product Update Status:
用户已选择不包括产品更新。

用户输入设置:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT Service\SQLSERVERAGENT
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: TABULAR
ASSVCACCOUNT: <空>
ASSVCPASSWORD: <空>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <空>
ASTELSVCACCT: <空>
ASTELSVCPASSWORD: <空>
ASTELSVCSTARTUPTYPE: 0
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <空>
CLTRESULTDIR: <空>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <空>
CLTSVCPASSWORD: <空>
CLTWORKINGDIR: <空>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220410_111328\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <空>
CTLRSVCPASSWORD: <空>
CTLRUSERS: <空>
ENABLERANU: false
ENU: false
EXTSVCACCOUNT: <空>
EXTSVCPASSWORD: <空>
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <空>
FTSVCACCOUNT: <空>
FTSVCPASSWORD: <空>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: true
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <空>
INSTANCEDIR: E:\APP\SQLServer
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
ISMASTERSVCPASSWORD: <空>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <空>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <空>
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD: <空>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: <空>
ISTELSVCPASSWORD: <空>
ISTELSVCSTARTUPTYPE: 0
ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
ISWORKERSVCCERT: <空>
ISWORKERSVCMASTER: <空>
ISWORKERSVCPASSWORD: <空>
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <空>
MATRIXNAME: <空>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: <空>
PBDMSSVCPASSWORD: <空>
PBDMSSVCSTARTUPTYPE: 0
PBENGSVCACCOUNT: <空>
PBENGSVCPASSWORD: <空>
PBENGSVCSTARTUPTYPE: 0
PBPORTRANGE: <空>
PBSCALEOUT: false
PID: *****
QUIET: true
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <空>
RSSVCPASSWORD: <空>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <空>
SECURITYMODE: <空>
SQLBACKUPDIR: <空>
SQLCOLLATION: Chinese_PRC_CI_AS
SQLJAVADIR: <空>
SQLMAXDOP: 8
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <空>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: LAPTOP-4U0BL3OV\H_kn
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <空>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <空>
SQLTEMPDBFILECOUNT: 8
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <空>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <空>
SQLUSERDBLOGDIR: <空>
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: false
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220410_111328\ConfigurationFile.ini

Detailed results:
Feature: 数据库引擎服务
Status: 失败
Reason for failure: 在此功能的安装过程中出错。
Next Step: 使用以下信息解决错误,然后再次尝试运行安装过程。
Component name: SQL Server 数据库引擎服务实例功能
Component error code: 1639
Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220410_111328\sql_engine_core_inst_Cpu64_1_Local.log
Error description: 无效的命令行参数。有关详细的命令行帮助,请查阅 Windows Installer 的 SDK。
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639

Feature: 安装程序支持文件
Status: 已通过

Feature: SQL 编写器
Status: 失败
Reason for failure: 已取消此功能的安装。
Next Step: SQL Server 安装程序在完成此操作之前已取消。请再次尝试运行安装过程。

Rules with failures or warnings:

Global rules:
警告 IsFirewallEnabled Windows 防火墙已启用。请确保相应端口已打开,以启用远程访问。若要了解为每项功能打开的端口,请参阅 https://go.microsoft.com/fwlink/?linkid=2094702 中的规则文档。

Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220410_111328\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.Configuration.Sco.ScoException
Message:
找不到注册表项“SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState”。
HResult : 0x84bb0001
FacilityCode : 1211 (4bb)
ErrorCode : 1 (0001)
Data:
DisableWatson = true
Stack:
在 Microsoft.SqlServer.Configuration.Sco.FeatureRegistration.SetFeatureFlag(String machine, String featureId, String flagName, String registryKey, Object flagState, RegistryView cpuView)
在 Microsoft.SqlServer.Configuration.Sco.FeatureRegistration.SetFeatureConfigState(String featureId, ConfigurationState configState, String version, RegistryView cpuView)
在 Microsoft.SqlServer.Configuration.SetupExtension.UpgradeIncompleteFeatureConfigEventHandler.MarkFeatureConfigured(FeatureId featureId, ConfigActionScenario scenario, Dictionary`2 actionData, String instanceId, Boolean keepFailedState)
在 Microsoft.SqlServer.Configuration.SetupExtension.UpgradeIncompleteFeatureConfigEventHandler.FeatureConfigurationExecutionEventHandler(Object sender, FeatureConfigScenarioEventArgs eventArgs, Boolean runValidation, Boolean featureFailed)
在 Microsoft.SqlServer.Configuration.SetupExtension.UpgradeIncompleteFeatureConfigEventHandler.FeatureConfigurationExecutionEventHandler(Object sender, Object[] objectArray)
在 Microsoft.SqlServer.Chainer.Infrastructure.NotificationHandler.Invoke(Object notification, Object[] objectArray)
在 Microsoft.SqlServer.Chainer.Infrastructure.NotificationService.OnNotify(Object eventKey, Object notification, Object[] objectArray)
在 Microsoft.SqlServer.Configuration.ConfigExtension.ConfigFeatureActionListener.InFeatureConfigurationExecutionEventHandler(ActionKey key, TextWriter loggingStream)
在 Microsoft.SqlServer.Setup.Chainer.Workflow.ActionMetadata.NotifyInExecution(ActionKey actionRunning, TextWriter loggingStream)
在 Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)

SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ronen Ariely 15,206 Reputation points
    2022-04-10T12:56:04.293+00:00

    Hello and welcome to the QnA forum Kning

    (1) This forum is for discussion in English.

    If you want to have the discussion in CHINESE, then you can move to the MSDN forums where the local (non-English) forums are: https://social.msdn.microsoft.com/Forums/zh-CN/home

    If you want to continue the discussions here then please move to English

    (2) The basic issue which you are dealing with is this: "Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState'."

    This thread discuss the exact same issue:

    https://learn.microsoft.com/en-us/answers/questions/216059/unable-to-install-sql-server-setupexe.html?WT.mc_id=DP-MVP-5001699

    According to the discussion, the source issue for some people was that they had an ssd (C:/) and an hdd (D:/) and Program Files folder was at D:/Program Files and not in the C disk.

    In this case, the solution which worked was to modified the registry so that the default installation path is D:/Program Files

    Check if this solve your issue please

    (3) If you installed SQL Server on that machine before, then try to repair the installation

    Run the setup.exe again as administrator, and select repair the installation.

    ----------

    Please inform us if one of the above solved you need or should we continue with more optional cases. In this case, please try to provide as much information as you can

    0 comments No comments

  2. YufeiShao-msft 7,146 Reputation points
    2022-04-11T06:08:24.75+00:00

    Hi @Kning ,

    Try to run the setup.exe again, repair the installation:
    191724-1.png

    If it does not work, refer to this article, uninstall SQL Server, disable any antivirus/security program, then reinstall and run setup.exe as administrator

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

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.