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代码

;sqlSERVER2008 Configuration File
[OPTIONS]

; 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. 

INSTANCEID="BNSDEV"

; Specifies a Setup work flow,like INSTALL,UNINSTALL,or UPGRADE. This is a required parameter. 

ACTION="Install"

; 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. 

FEATURES=sqlENGINE,REPLICATION

; Displays the command line parameters usage 

HELP="False"

; Specifies that the detailed Setup log should be piped to the console. 

INDICATEPROGRESS="False"

; Setup will not display any user interface. 

QUIET="False"

; Setup will display progress only without any user interaction. 

QUIETSIMPLE="False"

; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. 

X86="False"

; Detailed help for command line argument ROLE has not been defined yet. 

ROLE="AllFeatures_WithDefaults"

; Detailed help for command line argument ENU has not been defined yet. 

ENU="True"

; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,and AutoAdvance for a simplied UI. 

UIMODE="Normal"

; 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. 

ERRORREPORTING="True"

; Specify the root installation directory for native shared components. 

INSTALLSHAREDDIR="C:\Program Files\Microsoft sql Server"

; Specify the installation directory. 

INSTANCEDIR="C:\Program Files\Microsoft sql Server"

; 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. 

SQMREPORTING="False"

; 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). 

INSTANCENAME="BNSDEV"

; Agent account name 

AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

; Auto-start service after installation.  

AGTSVCSTARTUPTYPE="Disabled"

; Startup type for Integration Services. 

ISSVCSTARTUPTYPE="Automatic"

; Account for Integration Services: Domain\User or system account. 

ISSVCACCOUNT="NT AUTHORITY\NetworkService"

; Controls the service startup type setting after the service has been created. 

ASSVCSTARTUPTYPE="Automatic"

; The collation to be used by Analysis Services. 

ASCOLLATION="Latin1_General_CI_AS"

; The location for the Analysis Services data files. 

ASDATADIR="Data"

; The location for the Analysis Services log files. 

ASLOGDIR="Log"

; The location for the Analysis Services backup files. 

ASBACKUPDIR="Backup"

; The location for the Analysis Services temporary files. 

ASTEMPDIR="Temp"

; The location for the Analysis Services configuration files. 

ASCONFIGDIR="Config"

; Specifies whether or not the MSOLAP provider is allowed to run in process. 

ASPROVIDERMSOLAP="1"

; A port number used to connect to the SharePoint Central Administration web application. 

FARMADMINPORT="0"

; Startup type for the sql Server service. 

sqlSVCSTARTUPTYPE="Automatic"

; Level to enable FILESTREAM feature at (0,1,2 or 3). 

FILESTREAMLEVEL="0"

; Set to "1" to enable RANU for sql Server Express. 

ENABLERANU="True"

; Specifies a Windows collation or an sql collation to use for the Database Engine. 

sqlCOLLATION="sql_Latin1_General_CP1_CI_AS"

; Account for sql Server service: Domain\User or system account. 

sqlSVCACCOUNT="NT AUTHORITY\SYSTEM"

; Windows account(s) to provision as sql Server system administrators. 

sqlSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"

; Provision current user as a Database Engine system administrator for sql Server 2008 R2 Express. 

ADDCURRENTUSERASsqlADMIN="True"

; Specify 0 to disable or 1 to enable the TCP/IP protocol. 

TCPENABLED="1"

; Specify 0 to disable or 1 to enable the Named Pipes protocol. 

NPENABLED="0"

; Startup type for Browser Service. 

BROWSERSVCSTARTUPTYPE="Disabled"

; 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.
; The username part of RSSVCACCOUNT is a maximum of 20 characters long and
; The domain part of RSSVCACCOUNT is a maximum of 254 characters long. 

RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

; Specifies how the startup mode of the report server NT service.  When 
; Manual - Service startup is manual mode (default).
; Automatic - Service startup is automatic mode.
; Disabled - Service is disabled 

RSSVCSTARTUPTYPE="Automatic"

; Specifies which mode report server is installed in.  
; Default value: “FilesOnly”  

RSINSTALLMODE="FilesOnlyMode"

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

编辑

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

Overall summary:
  Final result:                  User cancelled
  Exit code (Decimal):           -2068380094
  Exit facility code:            1207
  Exit error code:               1602
  Exit message:                  User has cancelled.
  Start time:                    2017-10-30 13:27:09
  End time:                      2017-10-30 13:43:48
  Requested action:              Install

Machine Properties:
  Machine name:                  WINDOWS7-PC
  Machine processor count:       2
  OS version:                    Windows 7
  OS service pack:               Service Pack 1
  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 

Package properties:
  Description:                   sql Server Database Services 2008 R2
  ProductName:                   sql Server 2008 R2
  Type:                          RTM
  Version:                       10
  Installation location:         c:\3366571280411213122d3a8c\x86\setup\
  Installation edition:          EXPRESS

  Slipstream:                    True
  SP Level                       2

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
  ASDOMAINGROUP:                 <empty>
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\ConfigurationFile.ini
  CUSOURCE:                      
  ENABLERANU:                    True
  ENU:                           True
  ERRORREPORTING:                False
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      sqlENGINE,REPLICATION
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 *****
  HELP:                          False
  INDICATEPROGRESS:              False
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft sql Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft sql Server\
  INSTALLsqlDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft sql Server\
  INSTANCEID:                    BNSDEV
  INSTANCENAME:                  BNSDEV
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  NPENABLED:                     0
  PASSPHRASE:                    *****
  PCUSOURCE:                     c:\3366571280411213122d3a8c\PCUSOURCE
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 FilesOnlyMode
  RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
  RSSVCPASSWORD:                 *****
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  <empty>
  sqlBACKUPDIR:                  <empty>
  sqlCOLLATION:                  sql_Latin1_General_CP1_CI_AS
  sqlSVCACCOUNT:                 NT AUTHORITY\SYSTEM
  sqlSVCPASSWORD:                *****
  sqlSVCSTARTUPTYPE:             Automatic
  sqlSYSADMINACCOUNTS:           windows7-PC\windows7
  sqlTEMPDBDIR:                  <empty>
  sqlTEMPDBLOGDIR:               <empty>
  sqlUSERDBDIR:                  <empty>
  sqlUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  False
  TCPENABLED:                    0
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       sql Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft sql Server\100\Setup Bootstrap\Log\20171030_132528\SystemConfigurationCheck_Report.htm

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.sqlServer.Chainer.Infrastructure.CancelException
    Message: 
        User has cancelled.
    Stack: 
        at Microsoft.sqlServer.Configuration.UIExtension.Request.Wait()
        at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceProxy.SubmitAndWait(Request request)
        at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
        at Microsoft.sqlServer.Configuration.UIExtension.UserInterfaceService.Waypoint(String moniker)
        at Microsoft.sqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
        at Microsoft.sqlServer.Chainer.Infrastructure.Action.Execute(String actionId,TextWriter errorStream)
        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文件文件夹>>视图和在<<中添加的操作自定义操作>>视图.

相关文章

(一)日志传送架构 (1.1)相关服务器 主服务器 :用于生产的服务器,上面运行这生产SQL Server数据库...
(一)事故背景 最近在SQL Server 2012生产数据库上配置完事物复制(发布订阅)后,生产数据库业务出现了...
(一)测试目的 目前公司使用的SQL SERVER 2012高可用环境为主备模式,其中主库可执行读写操作,备库既...
(一)背景个人在使用sql server时,用到了sql server的发布订阅来做主从同步,类似MySQL的异步复制。在...
UNION和OR谓词 找出 product 和 product2 中售价高于 500 的商品的基本信息. select * from product wh...
datawhale组队学习task03