SQL Server installation failed

Question

Overall summary:
  Final result:                  失败: 请查看下面的详细信息
  Exit code (Decimal):           -2146232832
  Start time:                    2023-04-01 11:12:17
  End time:                      2023-04-01 11:18:33
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for AS:              使用以下信息解决错误，卸载此功能，然后再次运行安装过程。


Machine Properties:
  Machine name:                  COUNTRY
  Machine processor count:       16
  OS version:                    Microsoft Windows 11 家庭中文版 (10.0.22621)
  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:         D:\SQLserve\Developer_CHS\x64\setup\
  Installation edition:          Developer

Product Update Status:
  未发现任何更新。

Azul OpenJDK JRE 已安装。若要了解 Azul Zulu OpenJDK 第三方许可，请访问 https://www.azul.com/licenses-zulu-third-party-licenses/

用户输入设置:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      false
  AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   D:\SQLserve\MSAS15.MSSQLSERVER\OLAP\Backup
  ASCOLLATION:                   Chinese_PRC_CI_AS
  ASCONFIGDIR:                   D:\SQLserve\MSAS15.MSSQLSERVER\OLAP\Config
  ASDATADIR:                     D:\SQLserve\MSAS15.MSSQLSERVER\OLAP\Data
  ASLOGDIR:                      D:\SQLserve\MSAS15.MSSQLSERVER\OLAP\Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  TABULAR
  ASSVCACCOUNT:                  NT Service\MSSQLServerOLAPService
  ASSVCPASSWORD:                 <空>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            COUNTRY\13854
  ASTELSVCACCT:                  NT Service\SSASTELEMETRY
  ASTELSVCPASSWORD:              <空>
  ASTELSVCSTARTUPTYPE:           Automatic
  ASTEMPDIR:                     D:\SQLserve\MSAS15.MSSQLSERVER\OLAP\Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   
  CLTRESULTDIR:                  D:\SQLserve
  CLTSTARTUPTYPE:                Manual
  CLTSVCACCOUNT:                 NT Service\SQL Server Distributed Replay Client
  CLTSVCPASSWORD:                <空>
  CLTWORKINGDIR:                 D:\SQLserve
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230401_111155\ConfigurationFile.ini
  CTLRSTARTUPTYPE:               Manual
  CTLRSVCACCOUNT:                NT Service\SQL Server Distributed Replay Controller
  CTLRSVCPASSWORD:               <空>
  CTLRUSERS:                     COUNTRY\13854
  ENABLERANU:                    false
  ENU:                           false
  EXTSVCACCOUNT:                 <空>
  EXTSVCPASSWORD:                <空>
  FEATURES:                      SQLENGINE, REPLICATION, FULLTEXT, DQ, POLYBASECORE, POLYBASEJAVA, AS, DQC, CONN, IS, IS_MASTER, IS_WORKER, BC, SDK, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, MDS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <空>
  FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher
  FTSVCPASSWORD:                 <空>
  HELP:                          false
  IACCEPTPYTHONLICENSETERMS:     false
  IACCEPTROPENLICENSETERMS:      false
  IACKNOWLEDGEENTCALLIMITS:      false
  INDICATEPROGRESS:              false
  INSTALLSHAREDDIR:              D:\SQLserve\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <空>
  INSTANCEDIR:                   D:\SQLserve
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISMASTERSVCACCOUNT:            NT Service\SSISScaleOutMaster150
  ISMASTERSVCPASSWORD:           <空>
  ISMASTERSVCPORT:               8391
  ISMASTERSVCSSLCERTCN:          CN=country; CN=192.168.130.204
  ISMASTERSVCSTARTUPTYPE:        Automatic
  ISMASTERSVCTHUMBPRINT:         D08B1BAB54A1213C2CD9D5B0ECE42349A9BA4602
  ISSVCACCOUNT:                  NT Service\MsDtsServer150
  ISSVCPASSWORD:                 <空>
  ISSVCSTARTUPTYPE:              Automatic
  ISTELSVCACCT:                  NT Service\SSISTELEMETRY150
  ISTELSVCPASSWORD:              <空>
  ISTELSVCSTARTUPTYPE:           Automatic
  ISWORKERSVCACCOUNT:            NT Service\SSISScaleOutWorker150
  ISWORKERSVCCERT:               <空>
  ISWORKERSVCMASTER:             https://country:8391
  ISWORKERSVCPASSWORD:           <空>
  ISWORKERSVCSTARTUPTYPE:        Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <空>
  MATRIXNAME:                    <空>
  MRCACHEDIRECTORY:              
  NPENABLED:                     0
  PBDMSSVCACCOUNT:               NT AUTHORITY\NETWORK SERVICE
  PBDMSSVCPASSWORD:              <空>
  PBDMSSVCSTARTUPTYPE:           Automatic
  PBENGSVCACCOUNT:               NT AUTHORITY\NETWORK SERVICE
  PBENGSVCPASSWORD:              <空>
  PBENGSVCSTARTUPTYPE:           Automatic
  PBPORTRANGE:                   16450-16460
  PBSCALEOUT:                    false
  PID:                           *****
  QUIET:                         false
  QUIETSIMPLE:                   false
  ROLE:                          
  RSINSTALLMODE:                 DefaultNativeMode
  RSSVCACCOUNT:                  <空>
  RSSVCPASSWORD:                 <空>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  SQL
  SQLBACKUPDIR:                  <空>
  SQLCOLLATION:                  Chinese_PRC_CI_AS
  SQLJAVADIR:                    
  SQLMAXDOP:                     8
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCINSTANTFILEINIT:         false
  SQLSVCPASSWORD:                <空>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           COUNTRY\13854
  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:                 true
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false
  USESQLRECOMMENDEDMEMORYLIMITS: false
  X86:                           false

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

Detailed results:
  Feature:                       Master Data Services
  Status:                        已通过

  Feature:                       Data Quality Services
  Status:                        已通过

  Feature:                       全文和语义提取搜索
  Status:                        已通过

  Feature:                       适用于 HDFS 数据源的 Java 连接器
  Status:                        已通过

  Feature:                       针对外部数据的 PolyBase 查询服务
  Status:                        已通过

  Feature:                       数据库引擎服务
  Status:                        已通过

  Feature:                       SQL Server 复制
  Status:                        已通过

  Feature:                       Analysis Services
  Status:                        失败
  Reason for failure:            在此功能的安装过程中出错。
  Next Step:                     使用以下信息解决错误，卸载此功能，然后再次运行安装过程。
  Component name:                SQL Server Analysis Services
  Component error code:          0x80131600
  Error description:             无法启动服务。原因:  服务“MSSQLServerOLAPService”启动请求失败。
  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=0x88A466B0%400x857354B0&EvtType=0x88A466B0%400x857354B0

  Feature:                       SQL Browser
  Status:                        已通过

  Feature:                       SQL 编写器
  Status:                        已通过

  Feature:                       Distributed Replay 客户端
  Status:                        已通过

  Feature:                       Distributed Replay 控制器
  Status:                        已通过

  Feature:                       客户端工具向后兼容性
  Status:                        已通过

  Feature:                       客户端工具 SDK
  Status:                        已通过

  Feature:                       客户端工具连接
  Status:                        已通过

  Feature:                       Scale Out 辅助角色
  Status:                        已通过

  Feature:                       Scale Out 主要角色
  Status:                        已通过

  Feature:                       Integration Services
  Status:                        已通过

  Feature:                       SQL 客户端连接 SDK
  Status:                        已通过

  Feature:                       SQL 客户端连接
  Status:                        已通过

  Feature:                       Data Quality Client
  Status:                        已通过

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

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\20230401_111155\SystemConfigurationCheck_Report.html

Answer 1

I don't know Chinese, so I may be missing important details. But it appears that the only component that fails is SQL Server Analysis Services. Do you need Analysis Services?

If you are new to SQL Server, and you don't really know what Analysis Services is, the answer is, no, you don't need it. It's a specialised service for data warehouse stuff. Just as one point of reference: I can count as an SQL Server expert, but I don't know Analysis Services myself.

I would also recommend that you don't install the Polybase and Data Quality Service features. There is a risk, though, that you already have Polybase running, and if so, it may have already started to fill up your disk by constantly crashing. I would recommend that you download and install the most recent Cumulative Update for SQL 2019 to prevent this from happening.

Answer 2

Hi @COUNTRY,

  Feature:                       Analysis Services
  Status:                        失败
  Reason for failure:            在此功能的安装过程中出错。
  Next Step:                     使用以下信息解决错误，卸载此功能，然后再次运行安装过程。
  Component name:                SQL Server Analysis Services
  Component error code:          0x80131600

From the error message, please try to uninstall Analysis Services first and then run the setup again.

If you need to use Analysis Services, you may add the feature later.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.