sqlserver 2017 安装失败
0
[已关闭问题]
关闭于 2018-01-05 17:52
SqlServer 2017安装失败，错误代码1639，原来电脑上安装的是2008R2，准备安装一个2017自己做实验用，先在控制面板中卸载了2008R2 重启电脑后开始安装2017，卡在了sql_shared_mpyconfigaction_install_confignonrc_cpu64这个界面好久，后来过了2个小时后就安装失败了，认为是2008R2没有全部卸载的问题，尝试清除注册表和文件，再次安装依然是失败，错误日志如下所示，不知道该如何处理这个问题了，请指点迷津，多谢多谢
日志内容： 所需操作: 使用以下信息解决错误，然后再次尝试运行安装过程。 功能失败原因: 该功能的某个依赖项出错，导致该功能的安装过程失败。 错误详细信息: 安装 SQL Server 数据库引擎服务实例功能 时出错 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 错误代码: 1639 日志文件: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Overall summary: Final result: 失败: 请查看下面的详细信息 Exit code (Decimal): -2068052377 Start time: 2018-01-04 23:25:24 End time: 2018-01-05 01:23:06 Requested action: Install Setup completed with required actions for features. Troubleshooting information for those features: Next step for DQ: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for FullText: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for sql_inst_mpy: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for AdvancedAnalytics: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for SQLEngine: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for Replication: 使用以下信息解决错误，然后再次尝试运行安装过程。 Next step for AS: 使用以下信息解决错误，然后再次尝试运行安装过程。 Machine Properties: Machine name: DESKTOP-JVG6SLN Machine processor count: 4 OS version: Microsoft Windows 10 专业版 (10.0.16299) 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 2017 Master Data Services 2052 14.0.1000.169 否 否 Package properties: Description: Microsoft SQL Server 2017 ProductName: SQL Server 2017 Type: RTM Version: 14 SPLevel: 0 Installation location: V:\x64\setup\ Installation edition: Developer 用户输入设置: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT Service\SQLSERVERAGENT AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: E:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Backup ASCOLLATION: Chinese_PRC_CI_AS ASCONFIGDIR: E:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Config ASDATADIR: E:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Data ASLOGDIR: E:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: TABULAR ASSVCACCOUNT: NT Service\MSSQLServerOLAPService ASSVCPASSWORD: <空> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: DESKTOP-JVG6SLN\hnnyn ASTELSVCACCT: NT Service\SSASTELEMETRY ASTELSVCPASSWORD: <空> ASTELSVCSTARTUPTYPE: Automatic ASTEMPDIR: E:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <空> CLTRESULTDIR: <空> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <空> CLTSVCPASSWORD: <空> CLTWORKINGDIR: <空> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <空> CTLRSVCPASSWORD: <空> CTLRUSERS: <空> ENABLERANU: false ENU: false EXTSVCACCOUNT: NT Service\MSSQLLaunchpad EXTSVCPASSWORD: <空> FEATURES: SQLENGINE, REPLICATION, ADVANCEDANALYTICS, SQL_INST_MPY, FULLTEXT, DQ, AS, SQL_SHARED_AA, SQL_SHARED_MPY, DQC, CONN, BC FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <空> FTSVCACCOUNT: NT Service\MSSQLFDLauncher FTSVCPASSWORD: <空> HELP: false IACCEPTPYTHONLICENSETERMS: true IACCEPTROPENLICENSETERMS: false IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS: false INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <空> INSTANCEDIR: E:\Program Files\Microsoft SQL Server\ 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: false QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT: <空> RSSVCPASSWORD: <空> RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQL SQLBACKUPDIR: <空> SQLCOLLATION: Chinese_PRC_CI_AS SQLSVCACCOUNT: NT Service\MSSQLSERVER SQLSVCINSTANTFILEINIT: false SQLSVCPASSWORD: <空> SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: DESKTOP-JVG6SLN\hnnyn SQLTELSVCACCT: NT Service\SQLTELEMETRY SQLTELSVCPASSWORD: <空> SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR: <空> SQLTEMPDBFILECOUNT: 4 SQLTEMPDBFILEGROWTH: 64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR: <空> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE: 8 SQLUSERDBDIR: <空> SQLUSERDBLOGDIR: <空> SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: false UpdateSource: MU USEMICROSOFTUPDATE: false X86: false Configuration file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\ConfigurationFile.ini Detailed results: Feature: Data Quality Services Status: 失败 Reason for failure: 该功能的某个依赖项出错，导致该功能的安装过程失败。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Feature: 全文和语义提取搜索 Status: 失败 Reason for failure: 该功能的某个依赖项出错，导致该功能的安装过程失败。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: Python Status: 失败 Reason for failure: 该功能的某个依赖项出错，导致该功能的安装过程失败。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: 机器学习服务(数据库内) Status: 失败 Reason for failure: 该功能的某个依赖项出错，导致该功能的安装过程失败。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: 数据库引擎服务 Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: SQL Server 复制 Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: Analysis Services Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server Analysis Services Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_as_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink? Feature: 客户端工具连接 Status: 已通过 Feature: 客户端工具向后兼容性 Status: 已通过 Feature: Data Quality Client Status: 已通过 Feature: 机器学习服务器(独立) Status: 已通过 Feature: Python Status: 已通过 Feature: SQL 编写器 Status: 已通过 Rules with failures: Global rules: Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\SystemConfigurationCheck_Report.htm 上面报的错误日志内容如下： C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180104_232524\sql_engine_core_inst_Cpu64_1.log === Verbose logging started: 2018/1/4 23:29:28 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) (EC:44) [23:29:28:229]: Resetting cached policy values MSI (c) (EC:44) [23:29:28:229]: Machine policy value 'Debug' is 0 MSI (c) (EC:44) [23:29:28:229]: ******* RunEngine: ******* Product: V:\x64\setup\sql_engine_core_inst.msi ******* Action: ******* CommandLine: ********** MSI (c) (EC:44) [23:29:28:229]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (EC:44) [23:29:28:229]: Grabbed execution mutex. MSI (c) (EC:44) [23:29:28:229]: Cloaking enabled. MSI (c) (EC:44) [23:29:28:229]: Attempting to enable all disabled privileges before calling Install on Server MSI (c) (EC:44) [23:29:28:229]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (B0:68) [23:29:28:239]: Running installation inside multi-package transaction V:\x64\setup\sql_engine_core_inst.msi MSI (s) (B0:68) [23:29:28:239]: Grabbed execution mutex. MSI (s) (B0:48) [23:29:28:239]: Resetting cached policy values MSI (s) (B0:48) [23:29:28:239]: Machine policy value 'Debug' is 0 MSI (s) (B0:48) [23:29:28:239]: ******* RunEngine: ******* Product: V:\x64\setup\sql_engine_core_inst.msi ******* Action: ******* CommandLine: ********** MSI (s) (B0:48) [23:29:28:239]: Machine policy value 'TransformsSecure' is 0 MSI (s) (B0:48) [23:29:28:239]: User policy value 'TransformsAtSource' is 0 MSI (s) (B0:48) [23:29:28:268]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (B0:48) [23:29:28:268]: 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) (B0:48) [23:29:28:268]: MainEngineThread is returning 1639 MSI (s) (B0:68) [23:29:28:278]: User policy value 'DisableRollback' is 0 MSI (s) (B0:68) [23:29:28:278]: Machine policy value 'DisableRollback' is 0 MSI (s) (B0:68) [23:29:28:278]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (B0:68) [23:29:28:278]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (EC:44) [23:29:28:278]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (EC:44) [23:29:28:278]: MainEngineThread is returning 1639 === Verbose logging stopped: 2018/1/4 23:29:28 === === Verbose logging started: 2018/1/4 23:29:26 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) (EC:C0) [23:29:26:068]: Resetting cached policy values MSI (c) (EC:C0) [23:29:26:068]: Machine policy value 'Debug' is 0 MSI (c) (EC:C0) [23:29:26:068]: ******* RunEngine: ******* Product: V:\x64\setup\sql_as.msi ******* Action: ******* CommandLine: ********** MSI (c) (EC:C0) [23:29:26:068]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (EC:C0) [23:29:26:068]: Grabbed execution mutex. MSI (c) (EC:C0) [23:29:26:068]: Cloaking enabled. MSI (c) (EC:C0) [23:29:26:068]: Attempting to enable all disabled privileges before calling Install on Server MSI (c) (EC:C0) [23:29:26:068]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (B0:68) [23:29:26:078]: Running installation inside multi-package transaction V:\x64\setup\sql_as.msi MSI (s) (B0:68) [23:29:26:078]: Grabbed execution mutex. MSI (s) (B0:7C) [23:29:26:078]: Resetting cached policy values MSI (s) (B0:7C) [23:29:26:078]: Machine policy value 'Debug' is 0 MSI (s) (B0:7C) [23:29:26:078]: ******* RunEngine: ******* Product: V:\x64\setup\sql_as.msi ******* Action: ******* CommandLine: ********** MSI (s) (B0:7C) [23:29:26:078]: Machine policy value 'TransformsSecure' is 0 MSI (s) (B0:7C) [23:29:26:078]: User policy value 'TransformsAtSource' is 0 MSI (s) (B0:7C) [23:29:26:198]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (B0:7C) [23:29:26:198]: Specified instance {5B485C7F-A833-40C1-9080-1A2F30CEB4E2} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed. MSI (s) (B0:7C) [23:29:26:198]: MainEngineThread is returning 1639 MSI (s) (B0:68) [23:29:26:198]: User policy value 'DisableRollback' is 0 MSI (s) (B0:68) [23:29:26:198]: Machine policy value 'DisableRollback' is 0 MSI (s) (B0:68) [23:29:26:198]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (B0:68) [23:29:26:198]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (EC:C0) [23:29:26:208]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (EC:C0) [23:29:26:208]: MainEngineThread is returning 1639 === Verbose logging stopped: 2018/1/4 23:29:26 ===
问题补充：
重新安装了一遍，核心的log 就这一段
=== Verbose logging started: 2018/1/5 15:06:22 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) (F4:74) [15:06:22:953]: Resetting cached policy values
MSI (c) (F4:74) [15:06:22:953]: Machine policy value 'Debug' is 0
MSI (c) (F4:74) [15:06:22:953]: ******* RunEngine:
******* Product: V:\x64\setup\sql_as.msi
******* Action:
******* CommandLine: **********
MSI (c) (F4:74) [15:06:22:953]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (F4:74) [15:06:22:953]: Grabbed execution mutex.
MSI (c) (F4:74) [15:06:22:959]: Cloaking enabled.
MSI (c) (F4:74) [15:06:22:959]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (F4:74) [15:06:22:959]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (6C:E8) [15:06:22:968]: Running installation inside multi-package transaction V:\x64\setup\sql_as.msi
MSI (s) (6C:E8) [15:06:22:968]: Grabbed execution mutex.
MSI (s) (6C:1C) [15:06:22:969]: Resetting cached policy values
MSI (s) (6C:1C) [15:06:22:969]: Machine policy value 'Debug' is 0
MSI (s) (6C:1C) [15:06:22:969]: ******* RunEngine:
******* Product: V:\x64\setup\sql_as.msi
******* Action:
******* CommandLine: **********
MSI (s) (6C:1C) [15:06:22:970]: Machine policy value 'TransformsSecure' is 0
MSI (s) (6C:1C) [15:06:22:970]: User policy value 'TransformsAtSource' is 0
MSI (s) (6C:1C) [15:06:23:022]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (6C:1C) [15:06:23:022]: Specified instance {5B485C7F-A833-40C1-9080-1A2F30CEB4E2} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (6C:1C) [15:06:23:023]: MainEngineThread is returning 1639
MSI (s) (6C:E8) [15:06:23:025]: User policy value 'DisableRollback' is 0
MSI (s) (6C:E8) [15:06:23:025]: Machine policy value 'DisableRollback' is 0
MSI (s) (6C:E8) [15:06:23:025]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (6C:E8) [15:06:23:026]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (F4:74) [15:06:23:028]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (F4:74) [15:06:23:029]: MainEngineThread is returning 1639
=== Verbose logging stopped: 2018/1/5 15:06:23 ===
所有回答(4)
-1
重新装系统，肯定能解决。
重装系统 肯定可以解决，但已经安装了 太多的开发工具，时间成本太高了。。。
0
win10么，不想重装的话，开一个Hyper-V。然后安装一个centos，安装sql 2017。需要连接数据库的时候，启动一下Hyper-V
大哥 用过hyper-v 吗 ？睁着眼睛说瞎话 这玩意装centOs 经常会莫名其妙的出现驱动问题(本人亲自测试) 所以你就别在这里误导别人了
@CalvinR: 不会吧，我是用SERVER 2016安装的 一直很稳定，WIN10真没试过唉。
0
下载了一个 TotalUninstall 把sql相关的软件 都全部卸载掉，然后重装就可以了
0
根据我昨晚的安装经验 应该是在下载东西 其实有些东西是不需要安装的，可以不打钩
