我想使用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说.但我得到像这样的错误:
这是我在安装文件上的配置: