none
SQL Server 2019安裝失敗 RRS feed

  • 問題

  • 各位好!

    目前手邊有遇到Client端在安裝SQL Server 2019時發生錯誤,可以請大家幫忙看看應該如何排除嗎?

    感謝 :)

    Overall summary:
      Final result:                  失敗: 請參閱下面的詳細資料
      Exit code (Decimal):           -2068643839
      Start time:                    2020-03-10 10:53:21
      End time:                      2020-03-10 10:57:40
      Requested action:              Install
    
    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       使用下列資訊解決錯誤,然後重試一次安裝程序。
      Next step for SNAC_SDK:        使用下列資訊解決錯誤,然後重試一次安裝程序。
    
    
    Machine Properties:
      Machine name:                  DESKTOP-5ESE6DN
      Machine processor count:       4
      OS version:                    Microsoft Windows 10 家用版 (10.0.18362)
      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
      SQL Server 2012      <Unconfigured>       MSAS11.MSSQLSERVER2012         Analysis Services                        1033                                      11.0.2100.60    否          否         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          資料庫引擎服務                                  1033                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          資料庫引擎服務                                  1028                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          SQL Server 複寫                            1033                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          SQL Server 複寫                            1028                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          搜尋的全文檢索和語意擷取                             1033                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          Data Quality Services                    1033                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014      SQLSERVER2014        MSSQL12.SQLSERVER2014          Data Quality Services                    1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014      SQLSERVER2014        MSAS12.SQLSERVER2014           Analysis Services                        1033                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014      SQLSERVER2014        MSAS12.SQLSERVER2014           Analysis Services                        1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014      SQLSERVER2014        MSRS12.SQLSERVER2014           Reporting Services - 原生                  1033                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014      SQLSERVER2014        MSRS12.SQLSERVER2014           Reporting Services - 原生                  1028                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014                                                          SSMS                                     1028                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014                                                          Adv_SSMS                                 1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014                                                          用戶端工具連接性                                 1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014                                                          用戶端工具回溯相容性                               1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014                                                          用戶端工具 SDK                                1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014                                                          Data Quality Client                      1028                 Developer Edition    12.0.2000.8     否          是         
      SQL Server 2014                                                          Integration Services                     1028                 Developer Edition    12.0.2269.0     否          是         
      SQL Server 2014                                                          Reporting Services - SharePoint                                                    12.0.2269.0     否          是         
      SQL Server 2014                                                          Master Data Services                     1033                 Developer Edition    12.0.2254.0     否          是         
      SQL Server 2017      MSSQLSERVER2017      MSSQL14.MSSQLSERVER2017        資料庫引擎服務                                  1033                 Developer Edition    14.0.2027.2     否          是         
      SQL Server 2017      MSSQLSERVER2017      MSSQL14.MSSQLSERVER2017        資料庫引擎服務                                  1028                 Developer Edition    14.0.2027.2     否          是         
      SQL Server 2017      MSSQLSERVER2017      MSSQL14.MSSQLSERVER2017        SQL Server 複寫                            1033                 Developer Edition    14.0.2027.2     否          是         
      SQL Server 2017      MSSQLSERVER2017      MSSQL14.MSSQLSERVER2017        SQL Server 複寫                            1028                 Developer Edition    14.0.2027.2     否          是         
      SQL Server 2017                                                          用戶端工具連接性                                 1028                                      14.0.1000.169   否          是         
      SQL Server 2017                                                          用戶端工具回溯相容性                               1028                                      14.0.1000.169   否          是         
      SQL Server 2017                                                          用戶端工具 SDK                                1028                                      14.0.1000.169   否          是         
    
    Package properties:
      Description:                   Microsoft SQL Server 2019 
      ProductName:                   SQL Server 2019
      Type:                          RTM
      Version:                       15
      SPLevel:                       0
      Installation location:         H:\x64\setup\
      Installation edition:          Developer
    
    Product Update Status:
      未探索到任何項目。
    
    使用者輸入設定:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 NT Service\SQLAgent$MSSQLSERVER2019
      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:         Automatic
      CLTCTLRNAME:                   <空的>
      CLTRESULTDIR:                  <空的>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <空的>
      CLTSVCPASSWORD:                <空的>
      CLTWORKINGDIR:                 <空的>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200310_105321\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:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <空的>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER2019
      INSTANCENAME:                  MSSQLSERVER2019
      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:                         false
      QUIETSIMPLE:                   false
      ROLE:                          
      RSINSTALLMODE:                 DefaultNativeMode
      RSSVCACCOUNT:                  <空的>
      RSSVCPASSWORD:                 <空的>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <空的>
      SECURITYMODE:                  <空的>
      SQLBACKUPDIR:                  <空的>
      SQLCOLLATION:                  Chinese_Taiwan_Stroke_CI_AS
      SQLJAVADIR:                    <空的>
      SQLMAXDOP:                     4
      SQLMAXMEMORY:                  2147483647
      SQLMINMEMORY:                  0
      SQLSVCACCOUNT:                 NT Service\MSSQL$MSSQLSERVER2019
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                <空的>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           DESKTOP-5ESE6DN\ksi
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$MSSQLSERVER2019
      SQLTELSVCPASSWORD:             <空的>
      SQLTELSVCSTARTUPTYPE:          Automatic
      SQLTEMPDBDIR:                  <空的>
      SQLTEMPDBFILECOUNT:            4
      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\20200310_105321\ConfigurationFile.ini
    
    Detailed results:
      Feature:                       資料庫引擎服務
      Status:                        失敗
      Reason for failure:            功能的相依性發生錯誤,導致功能的安裝程序失敗。
      Next Step:                     使用下列資訊解決錯誤,然後重試一次安裝程序。
    
      Feature:                       SQL 用戶端連接性 SDK
      Status:                        失敗
      Reason for failure:            功能的安裝程序期間發生錯誤。
      Next Step:                     使用下列資訊解決錯誤,然後重試一次安裝程序。
    
    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\20200310_105321\SystemConfigurationCheck_Report.htm

    2020年3月10日 上午 03:03