sql-server – SQL Server无提示安装在安装期间出错
我想使用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 FilesMicrosoft SQL Server" ; Specify the installation directory. INSTANCEDIR="C:Program FilesMicrosoft 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 AUTHORITYNETWORK SERVICE" ; Auto-start service after installation. AGTSVCSTARTUPTYPE="Disabled" ; Startup type for Integration Services. ISSVCSTARTUPTYPE="Automatic" ; Account for Integration Services: DomainUser or system account. ISSVCACCOUNT="NT AUTHORITYNetworkService" ; 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: DomainUser or system account. SQLSVCACCOUNT="NT AUTHORITYSYSTEM" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="BUILTINADMINISTRATORS" ; 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 AUTHORITYNETWORK 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:3366571280411213122d3a8cx86setup Installation edition: EXPRESS Slipstream: True SP Level 2 User Input Settings: ACTION: Install ADDCURRENTUSERASSQLADMIN: True AGTSVCACCOUNT: NT AUTHORITYNETWORK 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 FilesMicrosoft SQL Server100Setup BootstrapLog20171030_132528ConfigurationFile.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 FilesMicrosoft SQL Server INSTALLSHAREDWOWDIR: C:Program FilesMicrosoft SQL Server INSTALLSQLDATADIR: <empty> INSTANCEDIR: C:Program FilesMicrosoft SQL Server INSTANCEID: BNSDEV INSTANCENAME: BNSDEV ISSVCACCOUNT: NT AUTHORITYNetworkService ISSVCPASSWORD: ***** ISSVCSTARTUPTYPE: Automatic NPENABLED: 0 PASSPHRASE: ***** PCUSOURCE: c:3366571280411213122d3a8cPCUSOURCE PID: ***** QUIET: False QUIETSIMPLE: False ROLE: AllFeatures_WithDefaults RSINSTALLMODE: FilesOnlyMode RSSVCACCOUNT: NT AUTHORITYNETWORK SERVICE RSSVCPASSWORD: ***** RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: <empty> SQLBACKUPDIR: <empty> SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS SQLSVCACCOUNT: NT AUTHORITYSYSTEM SQLSVCPASSWORD: ***** SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: windows7-PCwindows7 SQLTEMPDBDIR: <empty> SQLTEMPDBLOGDIR: <empty> SQLUSERDBDIR: <empty> SQLUSERDBLOGDIR: <empty> SQMREPORTING: False TCPENABLED: 0 UIMODE: Normal X86: False Configuration file: C:Program FilesMicrosoft SQL Server100Setup BootstrapLog20171030_132528ConfigurationFile.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 FilesMicrosoft SQL Server100Setup BootstrapLog20171030_132528SystemConfigurationCheck_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文件和文件夹>>视图和在<<中添加的操作自定义操作>>视图.(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |