我想使用Advanced Installer以静默方式安装sql Server Express(最好是2008或2014).我按照高级安装程序在线创建的两个文档中的说明操作:
How to Install SQL Server Express和here是一个示例* .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我得到一个错误因为系统找不到指定的文件和系统查找sqlSupport.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说.但我得到像这样的错误:
这是我在安装文件上的配置: