sql-server – SQL Server无提示安装在安装期间出错

前端之家收集整理的这篇文章主要介绍了sql-server – SQL Server无提示安装在安装期间出错前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我想使用Advanced Installer以静默方式安装sql Server Express(最好是2008或2014).我按照高级安装程序在线创建的两个文档中的说明操作:

How to Install SQL Server Expresshere是一个示例* .aip文件,用于显示静默安装sql Server Express所需的设置.

我的场景:

简单安装时出错:

但是,我收到此错误

我已经在目标系统上手动测试sql Server Express setup.exe.所以文件和目标系统没有任何问题.

我正在尝试使用ConfigurationFile.ini在命令行中设置如下:

这是我的ConfigurationFile.ini代码

  1. ;sqlSERVER2008 Configuration File
  2. [OPTIONS]
  3.  
  4. ; Specify the Instance ID for the sql Server features you have specified. sql Server directory structure,registry structure,and service names will reflect the instance ID of the sql Server instance.
  5.  
  6. INSTANCEID="BNSDEV"
  7.  
  8. ; Specifies a Setup work flow,like INSTALL,UNINSTALL,or UPGRADE. This is a required parameter.
  9.  
  10. ACTION="Install"
  11.  
  12. ; Specifies features to install,uninstall,or upgrade. The list of top-level features include sql,AS,RS,IS,and Tools. The sql feature will install the database engine,replication,and full-text. The Tools feature will install Management Tools,Books online,Business Intelligence Development Studio,and other shared components.
  13.  
  14. FEATURES=sqlENGINE,REPLICATION
  15.  
  16. ; Displays the command line parameters usage
  17.  
  18. HELP="False"
  19.  
  20. ; Specifies that the detailed Setup log should be piped to the console.
  21.  
  22. INDICATEPROGRESS="False"
  23.  
  24. ; Setup will not display any user interface.
  25.  
  26. QUIET="False"
  27.  
  28. ; Setup will display progress only without any user interaction.
  29.  
  30. QUIETSIMPLE="False"
  31.  
  32. ; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.
  33.  
  34. X86="False"
  35.  
  36. ; Detailed help for command line argument ROLE has not been defined yet.
  37.  
  38. ROLE="AllFeatures_WithDefaults"
  39.  
  40. ; Detailed help for command line argument ENU has not been defined yet.
  41.  
  42. ENU="True"
  43.  
  44. ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,and AutoAdvance for a simplied UI.
  45.  
  46. UIMODE="Normal"
  47.  
  48. ; Specify if errors can be reported to Microsoft to improve future sql Server releases. Specify 1 or True to enable and 0 or False to disable this feature.
  49.  
  50. ERRORREPORTING="True"
  51.  
  52. ; Specify the root installation directory for native shared components.
  53.  
  54. INSTALLSHAREDDIR="C:\Program Files\Microsoft sql Server"
  55.  
  56. ; Specify the installation directory.
  57.  
  58. INSTANCEDIR="C:\Program Files\Microsoft sql Server"
  59.  
  60. ; Specify that sql Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature.
  61.  
  62. SQMREPORTING="False"
  63.  
  64. ; Specify a default or named instance. MSsqlSERVER is the default instance for non-Express editions and sqlExpress for Express editions. This parameter is required when installing the sql Server Database Engine (sql),Analysis Services (AS),or Reporting Services (RS).
  65.  
  66. INSTANCENAME="BNSDEV"
  67.  
  68. ; Agent account name
  69.  
  70. AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
  71.  
  72. ; Auto-start service after installation.
  73.  
  74. AGTSVCSTARTUPTYPE="Disabled"
  75.  
  76. ; Startup type for Integration Services.
  77.  
  78. ISSVCSTARTUPTYPE="Automatic"
  79.  
  80. ; Account for Integration Services: Domain\User or system account.
  81.  
  82. ISSVCACCOUNT="NT AUTHORITY\NetworkService"
  83.  
  84. ; Controls the service startup type setting after the service has been created.
  85.  
  86. ASSVCSTARTUPTYPE="Automatic"
  87.  
  88. ; The collation to be used by Analysis Services.
  89.  
  90. ASCOLLATION="Latin1_General_CI_AS"
  91.  
  92. ; The location for the Analysis Services data files.
  93.  
  94. ASDATADIR="Data"
  95.  
  96. ; The location for the Analysis Services log files.
  97.  
  98. ASLOGDIR="Log"
  99.  
  100. ; The location for the Analysis Services backup files.
  101.  
  102. ASBACKUPDIR="Backup"
  103.  
  104. ; The location for the Analysis Services temporary files.
  105.  
  106. ASTEMPDIR="Temp"
  107.  
  108. ; The location for the Analysis Services configuration files.
  109.  
  110. ASCONFIGDIR="Config"
  111.  
  112. ; Specifies whether or not the MSOLAP provider is allowed to run in process.
  113.  
  114. ASPROVIDERMSOLAP="1"
  115.  
  116. ; A port number used to connect to the SharePoint Central Administration web application.
  117.  
  118. FARMADMINPORT="0"
  119.  
  120. ; Startup type for the sql Server service.
  121.  
  122. sqlSVCSTARTUPTYPE="Automatic"
  123.  
  124. ; Level to enable FILESTREAM feature at (0,1,2 or 3).
  125.  
  126. FILESTREAMLEVEL="0"
  127.  
  128. ; Set to "1" to enable RANU for sql Server Express.
  129.  
  130. ENABLERANU="True"
  131.  
  132. ; Specifies a Windows collation or an sql collation to use for the Database Engine.
  133.  
  134. sqlCOLLATION="sql_Latin1_General_CP1_CI_AS"
  135.  
  136. ; Account for sql Server service: Domain\User or system account.
  137.  
  138. sqlSVCACCOUNT="NT AUTHORITY\SYSTEM"
  139.  
  140. ; Windows account(s) to provision as sql Server system administrators.
  141.  
  142. sqlSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
  143.  
  144. ; Provision current user as a Database Engine system administrator for sql Server 2008 R2 Express.
  145.  
  146. ADDCURRENTUSERASsqlADMIN="True"
  147.  
  148. ; Specify 0 to disable or 1 to enable the TCP/IP protocol.
  149.  
  150. TCPENABLED="1"
  151.  
  152. ; Specify 0 to disable or 1 to enable the Named Pipes protocol.
  153.  
  154. NPENABLED="0"
  155.  
  156. ; Startup type for Browser Service.
  157.  
  158. BROWSERSVCSTARTUPTYPE="Disabled"
  159.  
  160. ; Specifies which account the report server NT service should execute under. When omitted or when the value is empty string,the default built-in account for the current operating system.
  161. ; The username part of RSSVCACCOUNT is a maximum of 20 characters long and
  162. ; The domain part of RSSVCACCOUNT is a maximum of 254 characters long.
  163.  
  164. RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
  165.  
  166. ; Specifies how the startup mode of the report server NT service. When
  167. ; Manual - Service startup is manual mode (default).
  168. ; Automatic - Service startup is automatic mode.
  169. ; Disabled - Service is disabled
  170.  
  171. RSSVCSTARTUPTYPE="Automatic"
  172.  
  173. ; Specifies which mode report server is installed in.
  174. ; Default value: FilesOnly
  175.  
  176. RSINSTALLMODE="FilesOnlyMode"

我认为PCUSOURCE肯定存在问题.因为as1我得到一个错误因为系统找不到指定的文件和系统查找sql​​Support.msi.
任何人都可以帮我解决这个问题吗?

编辑

这是安装的最后一个summery.txt:

  1. Overall summary:
  2. Final result: User cancelled
  3. Exit code (Decimal): -2068380094
  4. Exit facility code: 1207
  5. Exit error code: 1602
  6. Exit message: User has cancelled.
  7. Start time: 2017-10-30 13:27:09
  8. End time: 2017-10-30 13:43:48
  9. Requested action: Install
  10.  
  11. Machine Properties:
  12. Machine name: WINDOWS7-PC
  13. Machine processor count: 2
  14. OS version: Windows 7
  15. OS service pack: Service Pack 1
  16. OS region: United States
  17. OS language: English (United States)
  18. OS architecture: x86
  19. Process architecture: 32 Bit
  20. OS clustered: No
  21.  
  22. Product features discovered:
  23. Product Instance Instance ID Feature Language Edition Version Clustered
  24.  
  25. Package properties:
  26. Description: sql Server Database Services 2008 R2
  27. ProductName: sql Server 2008 R2
  28. Type: RTM
  29. Version: 10
  30. Installation location: c:\3366571280411213122d3a8c\x86\setup\
  31. Installation edition: EXPRESS
  32.  
  33. Slipstream: True
  34. SP Level 2
  35.  
  36. User Input Settings:
  37. ACTION: Install
  38. ADDCURRENTUSERASsqlADMIN: True
  39. AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
  40. AGTSVCPASSWORD: *****
  41. AGTSVCSTARTUPTYPE: Disabled
  42. ASBACKUPDIR: Backup
  43. ASCOLLATION: Latin1_General_CI_AS
  44. ASCONFIGDIR: Config
  45. ASDATADIR: Data
  46. ASDOMAINGROUP: <empty>
  47. ASLOGDIR: Log
  48. ASPROVIDERMSOLAP: 1
  49. ASSVCACCOUNT: <empty>
  50. ASSVCPASSWORD: *****
  51. ASSVCSTARTUPTYPE: Automatic
  52. ASSYSADMINACCOUNTS: <empty>
  53. ASTEMPDIR: Temp
  54. BROWSERSVCSTARTUPTYPE: Disabled
  55. CONFIGURATIONFILE: C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\ConfigurationFile.ini
  56. CUSOURCE:
  57. ENABLERANU: True
  58. ENU: True
  59. ERRORREPORTING: False
  60. FARMACCOUNT: <empty>
  61. FARMADMINPORT: 0
  62. FARMPASSWORD: *****
  63. FEATURES: sqlENGINE,REPLICATION
  64. FILESTREAMLEVEL: 0
  65. FILESTREAMSHARENAME: <empty>
  66. FTSVCACCOUNT: <empty>
  67. FTSVCPASSWORD: *****
  68. HELP: False
  69. INDICATEPROGRESS: False
  70. INSTALLSHAREDDIR: C:\Program Files\Microsoft sql Server\
  71. INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft sql Server\
  72. INSTALLsqlDATADIR: <empty>
  73. INSTANCEDIR: C:\Program Files\Microsoft sql Server\
  74. INSTANCEID: BNSDEV
  75. INSTANCENAME: BNSDEV
  76. ISSVCACCOUNT: NT AUTHORITY\NetworkService
  77. ISSVCPASSWORD: *****
  78. ISSVCSTARTUPTYPE: Automatic
  79. NPENABLED: 0
  80. PASSPHRASE: *****
  81. PCUSOURCE: c:\3366571280411213122d3a8c\PCUSOURCE
  82. PID: *****
  83. QUIET: False
  84. QUIETSIMPLE: False
  85. ROLE: AllFeatures_WithDefaults
  86. RSINSTALLMODE: FilesOnlyMode
  87. RSSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
  88. RSSVCPASSWORD: *****
  89. RSSVCSTARTUPTYPE: Automatic
  90. SAPWD: *****
  91. SECURITYMODE: <empty>
  92. sqlBACKUPDIR: <empty>
  93. sqlCOLLATION: sql_Latin1_General_CP1_CI_AS
  94. sqlSVCACCOUNT: NT AUTHORITY\SYSTEM
  95. sqlSVCPASSWORD: *****
  96. sqlSVCSTARTUPTYPE: Automatic
  97. sqlSYSADMINACCOUNTS: windows7-PC\windows7
  98. sqlTEMPDBDIR: <empty>
  99. sqlTEMPDBLOGDIR: <empty>
  100. sqlUSERDBDIR: <empty>
  101. sqlUSERDBLOGDIR: <empty>
  102. SQMREPORTING: False
  103. TCPENABLED: 0
  104. UIMODE: Normal
  105. X86: False
  106.  
  107. Configuration file: C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\ConfigurationFile.ini
  108.  
  109. Detailed results:
  110. Feature: Database Engine Services
  111. Status: Failed: see logs for details
  112. MSI status: Passed
  113. Configuration status: Passed
  114.  
  115. Feature: sql Server Replication
  116. Status: Failed: see logs for details
  117. MSI status: Passed
  118. Configuration status: Passed
  119.  
  120. Rules with failures:
  121.  
  122. Global rules:
  123.  
  124. Scenario specific rules:
  125.  
  126. Rules report file: C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\SystemConfigurationCheck_Report.htm
  127.  
  128. Exception summary:
  129. The following is an exception stack listing the exceptions in outermost to innermost order
  130. Inner exceptions are being indented
  131.  
  132. Exception type: Microsoft.sqlServer.Chainer.Infrastructure.CancelException
  133. Message:
  134. User has cancelled.
  135. Stack:
  136. at Microsoft.sqlServer.Configuration.UIExtension.Request.Wait()
  137. at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceProxy.SubmitAndWait(Request request)
  138. at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
  139. at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceService.Waypoint(String moniker)
  140. at Microsoft.sqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
  141. at Microsoft.sqlServer.Chainer.Infrastructure.Action.Execute(String actionId,TextWriter errorStream)
  142. at Microsoft.sqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream,ISequencedAction actionToRun)

在@herman asnswer之后编辑

作为@herman回答,我从文件文件夹中删除sqlserverExpr.exe,然后从Action中删除了动作命令.之后,我从先决条件中添加sqlserverExpr.exe,然后在设置文件选项卡配置值为@herman说.但我得到像这样的错误

这是我在安装文件上的配置:

解决方法

我认为将sql Server作为先决条件添加到项目中会更容易,而不是使用自定义操作启动它. Advanced Installer具有sql Server Express的预定义先决条件.只需去<<先决条件>>查看您的安装项目,并从那里添加所需的先决条件到您的项目中.然后从<<删除当前的setup.exe文件文件夹>>视图和在<<中添加的操作自定义操作>>视图.

猜你在找的MsSQL相关文章