Sql-Server
SQL Server 2017 安裝問題
在我的電腦/伺服器上安裝 SQL Server 2017 時，我收到安裝錯誤。
錯誤日誌
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052377 Start time: 2018-08-13 13:34:16 End time: 2018-08-13 13:37:03 Requested action: Install Setup completed with required actions for features. Troubleshooting information for those features: Next step for DQ: Use the following information to resolve the error, and then try the setup process again. Next step for FullText: Use the following information to resolve the error, and then try the setup process again. Next step for sql_inst_mpy: Use the following information to resolve the error, and then try the setup process again. Next step for sql_inst_mr: Use the following information to resolve the error, and then try the setup process again. Next step for AdvancedAnalytics: Use the following information to resolve the error, and then try the setup process again. 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 AS: Use the following information to resolve the error, and then try the setup process again. Machine Properties: Machine name: DESKTOP-KJGHCSV Machine processor count: 8 OS version: Microsoft Windows 10 Pro (10.0.17134) 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 2017 Client Tools Connectivity 1033 14.0.1000.169 No Yes SQL Server 2017 Client Tools Backwards Compatibility 1033 14.0.1000.169 No Yes SQL Server 2017 Client Tools SDK 1033 14.0.1000.169 No Yes SQL Server 2017 Data Quality Client 1033 Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Integration Services 1033 Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Scale Out Master 1033 Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Scale Out Worker 1033 Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Master Data Services 1033 Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Machine Learning Server (Standalone) Developer Edition 14.0.1000.169 No Yes SQL Server 2017 R Developer Edition 14.0.1000.169 No Yes SQL Server 2017 Python Developer Edition 14.0.1000.169 No Yes Package properties: Description: Microsoft SQL Server 2017 ProductName: SQL Server 2017 Type: RTM Version: 14 SPLevel: 0 Installation location: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\ Installation edition: Developer Product Update Status: None discovered. User Input Settings: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT Service\SQLSERVERAGENT AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Config ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Data ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: TABULAR ASSVCACCOUNT: NT Service\MSSQLServerOLAPService ASSVCPASSWORD: <empty> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: RADISE\HBopuri ASTELSVCACCT: NT Service\SSASTELEMETRY ASTELSVCPASSWORD: <empty> ASTELSVCSTARTUPTYPE: Automatic ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <empty> CLTRESULTDIR: <empty> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <empty> CLTSVCPASSWORD: <empty> CLTWORKINGDIR: <empty> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <empty> CTLRSVCPASSWORD: <empty> CTLRUSERS: <empty> ENABLERANU: false ENU: true EXTSVCACCOUNT: NT Service\MSSQLLaunchpad EXTSVCPASSWORD: <empty> FEATURES: SQLENGINE, REPLICATION, ADVANCEDANALYTICS, SQL_INST_MR, SQL_INST_MPY, FULLTEXT, DQ, AS FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <empty> FTSVCACCOUNT: NT Service\MSSQLFDLauncher FTSVCPASSWORD: <empty> HELP: false IACCEPTPYTHONLICENSETERMS: true IACCEPTROPENLICENSETERMS: true IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS: false INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <empty> INSTANCEDIR: C:\Program Files\Microsoft SQL Server\ INSTANCEID: MSSQLSERVER INSTANCENAME: MSSQLSERVER ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service ISMASTERSVCPASSWORD: <empty> ISMASTERSVCPORT: 8391 ISMASTERSVCSSLCERTCN: <empty> ISMASTERSVCSTARTUPTYPE: Automatic ISMASTERSVCTHUMBPRINT: <empty> ISSVCACCOUNT: NT AUTHORITY\Network Service ISSVCPASSWORD: <empty> ISSVCSTARTUPTYPE: Automatic ISTELSVCACCT: <empty> ISTELSVCPASSWORD: <empty> ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service ISWORKERSVCCERT: <empty> ISWORKERSVCMASTER: <empty> ISWORKERSVCPASSWORD: <empty> ISWORKERSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: <empty> MATRIXNAME: <empty> MRCACHEDIRECTORY: NPENABLED: 0 PBDMSSVCACCOUNT: <empty> PBDMSSVCPASSWORD: <empty> PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT: <empty> PBENGSVCPASSWORD: <empty> PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE: <empty> PBSCALEOUT: false PID: ***** QUIET: false QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT: <empty> RSSVCPASSWORD: <empty> RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQL SQLBACKUPDIR: <empty> SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS SQLSVCACCOUNT: NT Service\MSSQLSERVER SQLSVCINSTANTFILEINIT: true SQLSVCPASSWORD: <empty> SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: RADISE\HBopuri SQLTELSVCACCT: NT Service\SQLTELEMETRY SQLTELSVCPASSWORD: <empty> SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR: <empty> SQLTEMPDBFILECOUNT: 8 SQLTEMPDBFILEGROWTH: 64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR: <empty> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE: 8 SQLUSERDBDIR: <empty> SQLUSERDBLOGDIR: <empty> SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: true UpdateSource: MU USEMICROSOFTUPDATE: false X86: false Configuration file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\ConfigurationFile.ini Detailed results: Feature: Data Quality Services Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: Full-Text and Semantic Extractions for Search Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: Python Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: R Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: Machine Learning Services (In-Database) Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: Database Engine Services Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: SQL Server Replication Status: Failed 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 Database Engine Services Instance Features Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: Analysis Services Status: Failed 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 Analysis Services Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_as_Cpu64_1.log Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_as.msi%400x162A16FE%400x1639 Rules with failures: Global rules: Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\SystemConfigurationCheck_Report.htm核心組件日誌文件
C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log
=== Verbose logging started: 08/13/2018 13:36:57 Build type: SHIP UNICODE 5.00.10011.00 Calling process: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\ScenarioEngine.exe === MSI (c) (8C:28) [13:36:57:364]: Resetting cached policy values MSI (c) (8C:28) [13:36:57:364]: Machine policy value 'Debug' is 0 MSI (c) (8C:28) [13:36:57:364]: ******* RunEngine: ******* Product: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi ******* Action: ******* CommandLine: ********** MSI (c) (8C:28) [13:36:57:364]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (8C:28) [13:36:57:364]: Grabbed execution mutex. MSI (c) (8C:28) [13:36:57:365]: Cloaking enabled. MSI (c) (8C:28) [13:36:57:365]: Attempting to enable all disabled privileges before calling Install on Server MSI (c) (8C:28) [13:36:57:365]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (7C:E8) [13:36:57:367]: Running installation inside multi-package transaction C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi MSI (s) (7C:E8) [13:36:57:367]: Grabbed execution mutex. MSI (s) (7C:AC) [13:36:57:368]: Resetting cached policy values MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'Debug' is 0 MSI (s) (7C:AC) [13:36:57:368]: ******* RunEngine: ******* Product: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi ******* Action: ******* CommandLine: ********** MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'TransformsSecure' is 0 MSI (s) (7C:AC) [13:36:57:368]: User policy value 'TransformsAtSource' is 0 MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (7C:AC) [13:36:57:368]: Specified instance {DED314CA-0EFE-4593-9D66-EF75E5289A4C} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed. MSI (s) (7C:AC) [13:36:57:369]: MainEngineThread is returning 1639 MSI (s) (7C:E8) [13:36:57:369]: User policy value 'DisableRollback' is 0 MSI (s) (7C:E8) [13:36:57:369]: Machine policy value 'DisableRollback' is 0 MSI (s) (7C:E8) [13:36:57:369]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (7C:E8) [13:36:57:370]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (7C:E8) [13:36:57:370]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (7C:E8) [13:36:57:370]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (8C:28) [13:36:57:371]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (8C:28) [13:36:57:371]: MainEngineThread is returning 1639 === Verbose logging stopped: 08/13/2018 13:36:57 ===我已嘗試完全解除安裝 SQL Server，然後重新安裝，但仍然收到錯誤消息並且安裝失敗。
它失敗的原因是因為下面。
MSI (s) (7C:AC)
$$ 13:36:57:368 $$：指定實例 {DED314CA-0EFE-4593-9D66-EF75E5289A4C} 通過變換 :InstID01.mst;:InstName01.mst 已安裝。MSINEWINSTANCE 需要一個未安裝的新實例。
這意味著在 Windows 安裝程序系統資料庫中存在以前安裝的殘留物，這些殘留物在那裡留下了孤立的條目。您必須手動刪除它或使用某些工具。
這個部落格討論了類似的問題，並使用了 MS 工具來清理系統資料庫。部落格中的連結已失效，這是免費的 Windows 安裝程序清理實用程序，可用於清理。
PS：請在進行任何清理之前備份完整的系統資料庫。我不確定這個清理實用程序是如何工作的，所以你必須自己承擔風險
如果您有任何其他伺服器，請轉到服務並停止在 SQL Server 使用的同一埠上執行的服務。我遇到了同樣的問題，我停止了 MySQL 服務的執行並且它工作了。