配置 – 无人参与安装MS SQL Server(2008 | 2012)EXPRESS？

我的目标是安装MS SQL Server 2012 R2 Express.

我已下载SQLEXPRADV_x64_ENU.exe并使用/ ACTION = Install / UIMODE = Normal来生成和修改配置文件.无论我如何摆弄配置,它都会安装标准版的“默认”或“命名”实例,虽然我没有指定许可证(忽略this image中的红色箭头,我选择其他选项) ).

是什么赋予了？为了安装Express版本,我需要提供或更改哪个设置？

更新：我被告知我可能有错误的安装程序版本. (他们很高兴为所有版本命名相同.)我正在再次下载,不确定它是否不是我已经拥有的(如果我右键单击并选择“属性”,则告诉我它是“Microsoft SQL Server” 2012年高级版“).

我知道在哪里下载Microsoft SQL Server 2008 R2 Express,我知道在哪里下载Microsoft SQL Server 2012 Express,但在世界上哪里是Microsoft SQL Server 2012 R2 Express？客户希望使用“MS SQL Server R2 with Advanced Tools”,无论是2008年还是2012年(最终甚至是2014年).

既然你很可能会问这个,我在这里包括我的完整配置文件：

;SQL Server 2012 Configuration File

; DEVELOPER'S NOTE
; This file was obtained from the installer using the switches "/ACTION=Install /UIMODE=Normal" which yields the FULL set of wizard pages AND the ability to save a new configuration file.
; See also: https://technet.microsoft.com/en-us/library/ms144259%28v=sql.110%29.aspx

; Values that need to be changed before use:
;INSTANCENAME="{INSTANCENAME}"
;INSTANCEID="{INSTANCEID}"
;SQLSVCACCOUNT="NT ServiceMSSQL${INSTANCENAME}"
;SQLSVCPASSWORD="{SQLSVCPASSWORD}"
;SQLSYSADMINACCOUNTS="{HOSTNAME}Administrator"
;SAPWD="{SAPWD}"
;RSSVCACCOUNT="NT ServiceReportServer${INSTANCENAME}"
;FTSVCACCOUNT="NT ServiceMSSQLFDLauncher${INSTANCENAME}"
;QUIETSIMPLE="True" -- I recommend you pass "/QS" to the installer rather than editing this value

[OPTIONS]
; Required to acknowledge acceptance of the license terms.
IACCEPTSQLSERVERLICENSETERMS="True"
; Specifies a Setup work flow,like INSTALL,UNINSTALL,or UPGRADE. This is a required parameter.
ACTION="Install"
; 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,AutoAdvance for a simplied UI,and EnableUIOnServerCore for bypassing Server Core setup GUI block.
;UIMODE="Normal"
; Setup will not display any user interface.
;QUIET="False"
; Setup will display progress only,without any user interaction.
QUIETSIMPLE="False"
; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.
UpdateEnabled="False"
; Specifies features to install,uninstall,or upgrade. The list of top-level features include SQL,AS,RS,IS,MDS,and Tools. The SQL feature will install the Database Engine,Replication,Full-Text,and Data Quality Services (DQS) server. The Tools feature will install Management Tools,Books online components,SQL Server Data Tools,and other shared components.
FEATURES=SQL,DQC,Tools,SNAC_SDK
;FEATURES=SQLENGINE,REPLICATION,FULLTEXT,BIDS,BOL,SSMS,SNAC_SDK
; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update,a valid folder path,a relative path such as .MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services.
UpdateSource="MU"
; Displays the command line parameters usage
HELP="False"
; Specifies that the detailed Setup log should be piped to the console.
INDICATEPROGRESS="True"
; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.
X86="False"
; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed.
INSTALLSHAREDDIR="C:Program FilesMicrosoft SQL Server"
; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed.
INSTALLSHAREDWOWDIR="C:Program Files (x86)Microsoft SQL Server"
; 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="{INSTANCENAME}"
; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure,registry structure,and service names will incorporate the instance ID of the SQL Server instance.
INSTANCEID="{INSTANCEID}"
; 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"
; RSInputSettings_RSInstallMode_Description
RSINSTALLMODE="DefaultNativeMode"
; 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="False"
; Specify the installation directory.
INSTANCEDIR="C:Program FilesMicrosoft SQL Server"
; Agent account name
AGTSVCACCOUNT="NT AUTHORITYNETWORK SERVICE"
; Auto-start service after installation.
AGTSVCSTARTUPTYPE="Automatic"
; CM brick TCP communication port
COMMFABRICPORT="0"
; How matrix will use private networks
COMMFABRICNETWORKLEVEL="0"
; How inter brick communication will be protected
COMMFABRICENCRYPTION="0"
; TCP port used by the CM brick
MATRIXCMBRICKCOMMPORT="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 ServiceMSSQL${INSTANCENAME}"
SQLSVCPASSWORD="{SQLSVCPASSWORD}"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="{HOSTNAME}Administrator"
; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication.
SECURITYMODE="SQL"
SAPWD="{SAPWD}"
; Provision current user as a Database Engine system administrator for SQL Server 2012 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="1"
; Startup type for Browser Service.
BROWSERSVCSTARTUPTYPE="Disabled"
; Specifies which account the report server NT service should execute under.
RSSVCACCOUNT="NT ServiceReportServer${INSTANCENAME}"
; Specifies how the startup mode of the report server NT service.
RSSVCSTARTUPTYPE="Automatic"
; Add description of input argument FTSVCACCOUNT
FTSVCACCOUNT="NT ServiceMSSQLFDLauncher${INSTANCENAME}"

解决方法

我认为这将归结为错误的安装程序.我从您提到的链接下载了SQL Server 2012 Express高级版安装程序,并且能够广泛地遵循您的步骤,但我看到了一个显着的差异.

我的产品密钥屏幕与您的屏幕截图不同.我只在下拉菜单中列出Express,而不是“评估” – 我认为评估显示完全表明您已获得标准(或其他)版本安装程序.

验证安装程序的快速方法是使用不同的文件来比较哈希值.我在这个文件上得到的sha1哈希是E1F8DEC35422A67E6733E53ED260CCE538E97EDC. FCIV或Get-FileHash(PowerShell 4.0？)是Windows上的两个示例.

仅此一点并不是一个答案,所以我已经完成了无人值守的安装.首先,我像你一样创建了一个ConfigurationFile.ini.

无人值守安装

SQLEXPRADV_x64_ENU.exe /ACTION=Install /UIMode=Normal

（编辑：源码网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!