Sql-Server

無法安裝數據庫引擎服務、複製和 SQL 編寫器

  • November 9, 2017

我正在嘗試安裝 SQL Server 2012 Express，但出現此錯誤（我嘗試解除安裝並刪除系統資料庫項，嘗試將數據庫引擎的帳戶更改為 NT Authority\System，但重新安裝仍然無法正常工作）：

功能失敗原因：

功能的依賴項發生錯誤，導致功能的設置過程失敗。

錯誤詳情：

安裝 SQL Server 編寫器組件

時出錯 安裝程序在安裝此包時遇到意外錯誤。這可能表明包有問題。錯誤程式碼為 29559。

錯誤程式碼：29559

日誌文件：C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\SqlWriter_Cpu32_1.log

以下是設置引導程序的摘要：

Overall summary:
 Final result:                  Failed: see details below
 Exit code (Decimal):           -2068024457
 Start time:                    2016-03-10 23:00:02
 End time:                      2016-03-10 23:03:10
 Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
 Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.
 Next step for Replication:     Use the following information to resolve the error, and then try the setup process again.
 Next step for Writer:          Use the following information to resolve the error, and then try the setup process again.

Machine Properties:
 Machine name:                  NHAT-PC
 Machine processor count:       2
 OS version:                    Future Windows Version
 OS service pack:               
 OS region:                     United States
 OS language:                   English (United States)
 OS architecture:               x86
 Process architecture:          32 Bit
 OS clustered:                  No

Product features discovered:
 Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
 SQL Server 2012                                                          Management Tools - Basic                 1033                 Express Edition      11.2.5058.0     No         Yes       
 SQL Server 2012                                                          Management Tools - Complete              1033                 Express Edition      11.2.5058.0     No         Yes       
 SQL Server 2012                                                          Client Tools Connectivity                1033                 Express Edition      11.2.5058.0     No         Yes       
 SQL Server 2012                                                          Client Tools Backwards Compatibility     1033                 Express Edition      11.2.5058.0     No         Yes       
 SQL Server 2012                                                          Client Tools SDK                         1033                 Express Edition      11.2.5058.0     No         Yes       

Package properties:
 Description:                   Microsoft SQL Server 2012
 ProductName:                   SQL Server 2012
 Type:                          RTM
 Version:                       11
 Installation location:         E:\1885bc8762c587e3d8\x86\setup\
 Installation edition:          Express

 Slipstream:                    True
 SP Level                       2

Product Update Status:
 Success: KB 2958429

Product Updates Selected for Installation:
 Title:                         Service Pack 2
 Knowledge Based Article:       KB 2958429
 Version:                       11.2.5058.0
 Architecture:                  x86
 Language:                      1033

 Update Source:                 Slipstream


User Input Settings:
 ACTION:                        Install
 ADDCURRENTUSERASSQLADMIN:      true
 AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
 AGTSVCPASSWORD:                *****
 AGTSVCSTARTUPTYPE:             Disabled
 ASBACKUPDIR:                   Backup
 ASCOLLATION:                   Latin1_General_CI_AS
 ASCONFIGDIR:                   Config
 ASDATADIR:                     Data
 ASLOGDIR:                      Log
 ASPROVIDERMSOLAP:              1
 ASSERVERMODE:                  MULTIDIMENSIONAL
 ASSVCACCOUNT:                  <empty>
 ASSVCPASSWORD:                 <empty>
 ASSVCSTARTUPTYPE:              Automatic
 ASSYSADMINACCOUNTS:            <empty>
 ASTEMPDIR:                     Temp
 BROWSERSVCSTARTUPTYPE:         Automatic
 CLTCTLRNAME:                   <empty>
 CLTRESULTDIR:                  <empty>
 CLTSTARTUPTYPE:                0
 CLTSVCACCOUNT:                 <empty>
 CLTSVCPASSWORD:                <empty>
 CLTWORKINGDIR:                 <empty>
 COMMFABRICENCRYPTION:          0
 COMMFABRICNETWORKLEVEL:        0
 COMMFABRICPORT:                0
 CONFIGURATIONFILE:             
 CTLRSTARTUPTYPE:               0
 CTLRSVCACCOUNT:                <empty>
 CTLRSVCPASSWORD:               <empty>
 CTLRUSERS:                     <empty>
 ENABLERANU:                    true
 ENU:                           true
 ERRORREPORTING:                false
 FEATURES:                      SQLENGINE, REPLICATION
 FILESTREAMLEVEL:               0
 FILESTREAMSHARENAME:           <empty>
 FTSVCACCOUNT:                  <empty>
 FTSVCPASSWORD:                 <empty>
 HELP:                          false
 IACCEPTSQLSERVERLICENSETERMS:  true
 INDICATEPROGRESS:              false
 INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
 INSTALLSHAREDWOWDIR:           <empty>
 INSTALLSQLDATADIR:             <empty>
 INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
 INSTANCEID:                    DQN
 INSTANCENAME:                  DQN
 ISSVCACCOUNT:                  NT AUTHORITY\Network Service
 ISSVCPASSWORD:                 <empty>
 ISSVCSTARTUPTYPE:              Automatic
 MATRIXCMBRICKCOMMPORT:         0
 MATRIXCMSERVERNAME:            <empty>
 MATRIXNAME:                    <empty>
 NPENABLED:                     0
 PID:                           *****
 QUIET:                         false
 QUIETSIMPLE:                   false
 ROLE:                          AllFeatures_WithDefaults
 RSINSTALLMODE:                 DefaultNativeMode
 RSSHPINSTALLMODE:              DefaultSharePointMode
 RSSVCACCOUNT:                  <empty>
 RSSVCPASSWORD:                 <empty>
 RSSVCSTARTUPTYPE:              Automatic
 SAPWD:                         *****
 SECURITYMODE:                  SQL
 SQLBACKUPDIR:                  <empty>
 SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
 SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM
 SQLSVCPASSWORD:                *****
 SQLSVCSTARTUPTYPE:             Automatic
 SQLSYSADMINACCOUNTS:           NHAT-PC\nhat
 SQLTEMPDBDIR:                  <empty>
 SQLTEMPDBLOGDIR:               <empty>
 SQLUSERDBDIR:                  <empty>
 SQLUSERDBLOGDIR:               <empty>
 SQMREPORTING:                  false
 TCPENABLED:                    0
 UIMODE:                        AutoAdvance
 UpdateEnabled:                 true
 UpdateSource:                  Slipstream
 X86:                           false

 Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\ConfigurationFile.ini

Detailed results:
 Feature:                       Database Engine Services
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
 Next Step:                     Use the following information to resolve the error, and then try the setup process again.
 Component name:                SQL Server Writer Component
 Component error code:          29559
 Component log file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\SqlWriter_Cpu32_1.log
 Error description:             The installer has encountered an unexpected error installing this package. This may indicate a problem with the package. The error code is 29559.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=SqlWriter.msi%40Do_sqlServiceSidType_32%4029559

 Feature:                       SQL Server Replication
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
 Next Step:                     Use the following information to resolve the error, and then try the setup process again.
 Component name:                SQL Server Writer Component
 Component error code:          29559
 Component log file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\SqlWriter_Cpu32_1.log
 Error description:             The installer has encountered an unexpected error installing this package. This may indicate a problem with the package. The error code is 29559.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=SqlWriter.msi%40Do_sqlServiceSidType_32%4029559

 Feature:                       SQL Writer
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred during the setup process of the feature.
 Next Step:                     Use the following information to resolve the error, and then try the setup process again.
 Component name:                SQL Server Writer Component
 Component error code:          29559
 Component log file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\SqlWriter_Cpu32_1.log
 Error description:             The installer has encountered an unexpected error installing this package. This may indicate a problem with the package. The error code is 29559.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=SqlWriter.msi%40Do_sqlServiceSidType_32%4029559

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20160310_225904\SystemConfigurationCheck_Report.htm

我的機器是 Windows 10 x86，只有 2GB 的 RAM。

設置日誌文件SqlWriter_Cpu32_1.log的內容可在此處獲得（託管在 OneDrive 上）。

解決了這個問題：我在同一台機器上有一個舊的 SQL Server。當我刪除舊文件夾時，我刪除了所有文件夾並執行 ccleaner 來清理系統資料庫。這在機器上留下了損壞的 sqlwriter 服務。我使用“sc delete sqlwriter”將其刪除。一旦我這樣做，它執行正常。我認為有幫助的另一件事是以管理員身份執行 sql server 安裝程序。

從您發布的日誌中，我們有

配置服務：名稱：SQLWriter SID 類型：0x1 失敗：無法將服務 SQLWriter 的 SID 類型設置為 1。錯誤程式碼：2。

錯誤描述：安裝程序在安裝此軟體包時遇到意外錯誤。這可能表明包有問題。錯誤程式碼為 29559。

這裡的錯誤程式碼 2表示system cannot find the file specified. 這也是另一條消息所說的。當您收到此類消息時，可能是因為您下載的軟體包已損壞和某些文件失去或執行安裝的帳戶無權訪問該文件的兩個原因。我相信它正在尋找的文件是C:\WINDOWS\Installer\MSIEC4A.tmp因為以下

MSI (s) (E4: F4)

$$ 23:02:57:785 $$：呼叫遠端自定義操作。DLL： C:\WINDOWS\Installer\MSIEC4A.tmp，入口點：Do_sqlServiceSidType Function=Do_sqlServiceSidType 執行操作：Do_sqlServiceSidType PerfTime 開始：Do_sqlServiceSidType：2016 年 3 月 10 日星期四 23:02:57 配置服務：名稱：SQLWriter SID 類型：0x1 失敗：無法將服務 SQLWriter 的 SID 類型設置為 1。錯誤程式碼：2。

所以我假設查找是針對上述 DLL 的，但沒有找到。

你還可以做的是

  1. 再次下載 SQL Server 2012 快速安裝程序
  2. 確保滿足與 .net 框架特別相關的所有硬體和軟體要求。我強烈建議您在再次繼續安裝之前閱讀這篇文章
  3. 確保您始終右鍵點擊setup.exe文件並選擇run as administrator.
  4. 確保您用於執行安裝的帳戶對系統驅動器 C:\Windows\ 具有完全權限

當您第二次開始安裝時，不要安裝已經安裝的 SQL Server 客戶端工具。

**注意：**這是低級故障排除，MS 工程師可以提供更詳細和準確的資訊。

引用自：https://dba.stackexchange.com/questions/131913

相關問答

Sql-Server

SQL Server express - Management Studio 安裝在本機映像安裝時掛起

  • January 3, 2016
檢視問答
Sql-Server

SQL Server 2012 安裝靜默失敗

  • March 8, 2022
檢視問答
Sql-Server

Sql Server 安裝找不到文件

  • January 16, 2021
檢視問答
Sql-Server

當我已經在執行 SQL Server 2014 時，是否應該安裝 SQL Server 2012 SP3？

  • May 7, 2020
檢視問答
Sql-Server

我可以在本地安裝 SQL Server Management Studio 嗎？

  • May 7, 2020
檢視問答
Sql-Server

在 SQL Server Express 2012 SP1 中找不到數據庫郵件功能

  • September 12, 2019
檢視問答